Hi,

In Oracle, I created a table with nn columns.
In one of the columns I defined a default value.
Now the default value is not valid anymore.
I would like to keep the column but remove the default.

Is there a way to remove the default of the column of a table ?

The following is an example of my question:

create table test (
t1 number,
t2 number default 0
) ;

insert into test(t1,t2) values (1,1);
insert into test(t1) values (2);

-- The following does not work to remove the default
alter table test modify (
t2 number) ;

insert into test(t1) values (3);

Any ideas besides dropping and recreating the column ?