Table Constraints

[fugarte]

Hi,

What is the Alter Table SQL commands to add a not null constraint to a pre-existing field of a pre-existing table. I want Oracle to create the constraint name automatically.

Thanks for your help
Frank

 

[rcurva]

hERE'S HOW YOU DO IT:

ALTER TABLE table1
MODIFY column1 NOT NULL;
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War