Database 11g

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