Re: How to remove NOT NULL constraint from columns?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 15 Mar 2004 01:44:43 GMT
Message-ID: <fU75c.11882$Eg3.1459@nwrdny01.gnilink.net>

"Andrew" <myfam_at_surfeu.fi> wrote in message news:c5826e91.0403141700.54b3428d_at_posting.google.com...
> Hi,
> what is the easiest way to convert table so that NOT NULL constraint
> will be removed? Table is used by an application and has data.
>
> Thanks,
> Andrei

alter table <tablename> modify <columnname> null;

or (this one probably version dependent):

find the constraint name from user_constraints and do:

alter table <tablename> drop constraint <constraintname>;

Anurag Received on Sun Mar 14 2004 - 19:44:43 CST