Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: how to drop NOT-NULL constraint on a column?!
David K. Van Zandt wrote:
>
> 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
Hi,
alter table <tablename> drop constraint <constraintname>;
-- Regards Matthias Gresz :-)Received on Fri Nov 28 1997 - 00:00:00 CST