9.9.DROP TABLE Statement

drop_table
        : DROP TABLE q_table_name
        ;

This statement drops a table. This requires dba privileges or ownership of the table. Any subtables are automatically dropped. Supertables are not affected.