SQL Drop Table

The drop table statement requires the name of the table as specified in the eXtremeSQL Metatable. For example:

 
    drop table t;
 

The drop table statement deletes all data from the table and removes the table from the schema. For example, after dropping table Account, the SQL compiler no longer recognizes the table:

 
    XSQL>drop table Account;
    XSQL>select * from Account;
    ERROR: Compiler error at position 20: Unknown table Account