¶
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.