SQL & PL/SQL

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!

DROP nonexistent constraint

360534Apr 21 2005 — edited Apr 21 2005

Hi,
I have a requirement as below:
ALTER TABLE DEBUGDATA DROP constraint check_insert_size;

Now this constraint(check_insert_size) may exist on the table(DEBUGDATA) or not.

I need my ALTER statement to not give any error if the constaint doesnot exist and delete if it exist.

Is this possible.

Thanks,
Tuhin

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2005

Added on Apr 21 2005

4 comments

785 views