Removing default

[chidi]

I created a table with certain fields and some defaults.
Example: create table T (
first_name varchar2(25) default 'John');
If I need to remove this default, is there a simpler way of doing it?
thanks in advance

 

[jee]

You have probably found that doing something like;

alter table t
   modify first_name varchar2(20);
[\code]

doesn't work... the default still exists. You can do a couple of things that will have the effect of removing the default:

[code]
alter table t
   modify first_name varchar2 default '';

or

alter table t
   modify first_name varchar2 default NULL;
[\code]

 

[jee]

Whoops, in my examples I left off the

(20)

after the varchar2

sorry.