Quadcap Embeddable Database

• QED Home
• User's Guide
• Developer's Guide
• API Documentation
• SQL Reference
• FAQ
• Changes

Quadcap Software

• Home
• Download
• Products
• Services
• Purchase
• Support
• About

The DROP TABLE and DROP VIEW statements are used to remove a table/view definition and all of the data contained in the specified table. If RESTRICT is specified, no view or constraint may currently be referencing the table to be dropped. If CASCADE is specified (the default), any such referencing views and constraints are deleted along with the specified table or view.

dropTableStmt
  :  "drop" 
    (  "table" 
    |  "view" 
    ) 
    sqlId 
    (  "cascade" 
    |  "restrict" 
    |  
    ) 
    
  ;

DROP TABLE STAFF;
DROP VIEW WORKS RESTRICT;

None.