Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dropping not null constraint

392236Nov 27 2003 — edited Nov 27 2003

Hi

I wanted to know how can a not null constraint be dropped.
Using the 'Alter table drop constraint...' statement, this can be done but if the constraint is system defined and we dont want to search the constraint name first, is there any other option ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 25 2003

Added on Nov 27 2003

#general-database-discussions

1 comment

453 views