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.
Destroying a table with an implicitly-created index will also destroy the index.