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

1. Oracle PL/SQL Tutorial
2. Table
3. Drop Table

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>