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.

Examples

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.