Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to drop NOT-NULL constraint on a column?!
I don't get it, do you want to add or to drop the not-null constraint?
If you want to add it, make sure all rows contain data in that column, and then:
alter table table_xyz modify (column_abc not null);
-- ------------ Kind reGards \ / | X | / \ x Gerard David K. Van Zandt <dvanzandt_at_iquest.net> schreef in artikel <347DAFD1.D2CDEA73_at_iquest.net>...Received on Fri Nov 28 1997 - 00:00:00 CST
> Hi all, a question on which I'm not finding a book answer -- used to be,
> that the only way to change a table column from NULL to NOT NULL, or
> back, was to export, drop the table, recreate it, and re-import.
>
> For Oracle 7.1 and above, is there an easier way? It seems to be the
> only table constraint one cannot drop.... TIA!
>
> --
> Dave Van Zandt, CDP
> (work) dvanzand@IndyGov.org http://www.IndyGov.org
> (pers) dvanzandt@iquest.net http://members.iquest.net/~dvanzandt
>
>
>