The SQL command to permanently destroy a table is DROP TABLE. The following is
the syntax for DROP TABLE, where
tablename
is the table that you
wish to destroy:
DROP TABLE
tablename
Use caution when dropping a table, as doing so destroys all data associated with the table.
Note: Destroying a table with an implicitly-created index will destroy any associated indices.