The DROP Clause

This allows you to remove the named object from the database.

DROP tableName
DROP indexName ON tableName