DROP TABLE table_reference
DROP INDEX index_reference
Description
Use DROP do completely remove the database object and all appropriate files from the database.
DROP INDEX OrderIdIdx
DROP TABLE Orders
Warning
While an index deleted by error can be re-created easily, the data in a dropped table is gone and cannot be restored.