Moin's DBA Blog
Oracle DBA 24x7 You Can Contact me at : moinblog79@gmail.com
Database 11g
Home
Monday, July 11, 2016
How to Drop a Multi-Column Which is Having Constraints in Oracle
SQL> alter table pmpmcstk drop (pshscd,psbtn);
ERROR at line 1:
ORA-12991: column is referenced in a multi-column constraint
SQL> alter table pmpmcstk drop (pshscd,psbtn) cascade constraints;
Table altered.
Happy Learning...
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment