DROP TABLE with CASCADE CONSTRAINTS : Drop Table « Table « Oracle PL/SQL Tutorial






SQL>
SQL> CREATE TABLE ONSITE_SCHEDULE (
  2    SALESMAN_ID   NUMBER,
  3    VISIT_DATE    DATE,
  4    COMPANY_NAME  VARCHAR2(50),
  5    COMPANY_URL   VARCHAR2(200) ) ;

Table created.

SQL>
SQL> DROP TABLE ONSITE_SCHEDULE CASCADE CONSTRAINTS ;

Table dropped.

SQL>








6.8.Drop Table
6.8.1.Dropping a Table
6.8.2.DROP TABLE with CASCADE CONSTRAINTS
6.8.3.ORA-04091: table JAVA2S.DETAIL_TABLE is mutating, trigger/function may not see it
6.8.4.Drop only if table exists.