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>...


> 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

> 

> 

>