modify table column

[tsp120]

I expect this should be an easy issue, I just can't find anything on the net to give me a definite answer.

I have a table 'sources' with a column 'status'. I believe that the default value for this column is 'N', but I'm not sure. How can I see this? If I do:

Desc sources;

it does not show default values.

Secondly, I want to change the default value to NULL. How do I do this?

Thanks.

 

[Turkbear]

Hi,
Try:

Alter table sources modify status default NULL;

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[stefanhei]

Query user_tab_columns to see the default values:

SELECT column_name,data_default 
  FROM user_tab_columns
 WHERE table_name = 'SOURCES'

Stefan

 

[tsp120]

Thanks. I figured it would work like that.

However, is there any way I can see what the default value is on a column to make sure I did it correctly?

Thanks again.

 

[tsp120]

N/M, already answered. Thanks!

Everything works fine now.