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!

how to drop all constraints on a table?

Erhan_torontoSep 5 2013 — edited Sep 6 2013

Oracle 11gR2

------------------------------------------

I tried this but no luck!

ALTER TABLE testDB.dbo.testTable1 DROP ALL CONSTRAINT GO

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2013

Added on Sep 5 2013

#oracle, #performance, #query, #sqlplus

5 comments

12,217 views