Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to drop NOT-NULL constraint on a column?!

Re: how to drop NOT-NULL constraint on a column?!

From: David K. Van Zandt <dvanzandt_at_iquest.net>
Date: 1997/11/28
Message-ID: <347EC9D7.BF945CF3@iquest.net>#1/1

Gerard H. Pille wrote:

> 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);
> --

Yes, but changing NOT NULL to NULL doesn't seem to work.... We're removing, not adding, the constraint. Received on Fri Nov 28 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US