Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

DROP TABLE with CASCADE CONSTRAINTS

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>