The SQL command to permanently destroy a table is DROP TABLE . The following is the syntax for DROP TABLE , where table is the table that you wish to destroy:

  DROP TABLE table

Caution must be taken when dropping a table, as it destroys all data associated with the table as well.

Note Implicit Indices
 

Destroying a table with an implicitly-created index will also destroy the index.