Quadcap Software

Quadcap Embeddable Database

Quadcap Software

DROP TABLE and DROP VIEWS Statements

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.

Syntax

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


Examples

DROP TABLE STAFF;
DROP VIEW WORKS RESTRICT;

Implementation Notes

None.