changing column type from 'not null' to null

rajandhla · Posted: Tue Mar 11, 2008 11:47 am

Hi all,

Is there any way to change the column type from 'not null' to null.

I have created a table with column type as not null, now i would like to change it to null.

Please let me know if there any way to do it.

Many thanks,
Jai

ashwinreddy · Posted: Tue Mar 11, 2008 12:06 pm

Hi,

Found some notes in Google, hope this helps

www.mckoi.com/database/mail/subject.jsp?id=7300

Cheers
Ashwin

rajandhla · Posted: Tue Mar 11, 2008 2:18 pm

I tried with this syntax...

in db2 i think we need to use drop constraint key word.

vasanthkumarhb · Posted: Tue Mar 11, 2008 3:03 pm

Hi.......

You can do it by using ALTER Command............

rajandhla · Posted: Tue Mar 11, 2008 3:18 pm

I tried using the following query but it is giving error

Alter table <table name>
drop constraint <column name>;

Can u please correct it if nay thing is missing.

Thanks

vasanthkumarhb · Posted: Tue Mar 11, 2008 3:27 pm

Hi.......

If u drop constraint the related foreign key relation ships will also be get affected. you just want to change "NOT NULL' to 'NULL". You can just go for ALTER COLUMN statement

rajandhla · Posted: Tue Mar 11, 2008 3:45 pm

Thanks for your help Dear,

Still iam facing the problem with syntax... if you don't mind can you please provide me the complete syntax?

Regards,
Jai

vasanthkumarhb · Posted: Tue Mar 11, 2008 4:23 pm

Hi..

Just try the below statement and let me know.

Craq Giegerich · Posted: Tue Mar 11, 2008 5:00 pm

I think you will have to drop the table and redefine it.

rajandhla · Posted: Tue Mar 11, 2008 5:32 pm

I think there is a way... but iam unable to do it....

The query given by Vasanth is also giving error....

Any other ideas...

Regards,
Jai