Hi All,


I have one problem.
We have created one table with not null constraint.
Now I want to alter those columns back to null.
I have fired following syntax but it's not happening...
Can anybody help me out..

1. ALTER TABLE test ALTER COLUMN age DROP NULL;
2. ALTER TABLE test ALTER COLUMN age SET NULL;

Plese reply ASAP.


Regards,

Bhushan Sawant

Hi,

create table T1
( age date not null )

alter table T1 modify age date null;

Warning, not use DROP.

Gustavo.

Thanks Gustav,

I could achive this by using following ...

--------------------
alter table test modify(function_id integer);
--------------------
1. Don't specify "null" by default it takes null.
2. Specify "not null" to convert from null to not null.

This is to share my experiance with others...

Bhushan Sawant

Hi Bhushan,

Warning:
If the table have constraint the sentence
--------------------
alter table test modify(function_id integer);
--------------------
lost them.

Gustavo.