Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Q: how to drop NOT-NULL constraint on a column?!
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, CDPReceived on Thu Nov 27 1997 - 00:00:00 CST
(work) dvanzand@IndyGov.org http://www.IndyGov.org
(pers) dvanzandt@iquest.net http://members.iquest.net/~dvanzandt