remove NOT NULL constraint
765048Jun 13 2010 — edited Jun 14 2010I have a table ABC with column name A set to NOT NULL.
Name Null?
----------------------------------------- --------
A NOT NULL
I wish to change the status of A to have the NOT NULL constraint remove.
I need to use just ALTER TABLE A command
alter table ABC
modify(
A number
);
but it doesn't work.
I was told i should use MODIFY CONSTRAINT instead of just modify.
Mind anyone show me some examples?
and also can some one show me how to remove if i were to go into the Select * from constraint.... mode?
thanks