|Previous Top Next|
Delete a table or an index from the database.
DROP TABLE table_reference
DROP INDEX table_reference.index_name
DROP FULLTEXTINDEX table_reference.index_name
Use DROP to completely remove the database object and all appropriate files from the database.
DROP INDEX Orders.OrderIdIdx
DROP TABLE Orders
While an index deleted by error can be re-created easily, the data in a dropped table is gone and cannot be restored.