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

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