TurboSQL Guide DROP Statement |
Previous Top Next |
Delete a table or an index from the database.
Syntax
DROP TABLE table_reference
DROP INDEX table_reference.index_name
DROP FULLTEXTINDEX table_reference.index_name
Description
Use DROP to completely remove the database object and all appropriate files from the database.
DROP INDEX Orders.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.