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

alter table table_xyz modify (column_abc null)

David K. Van Zandt <dvanzandt_at_iquest.net> wrote in article <347EC9D7.BF945CF3_at_iquest.net>...
> 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