DROP Statement

SQL DROP Statement

The DROP statement is used to delete object in SQL, with the DROP statement we can remove index, tables and even databases easily.

DROP INDEX

The indexes of the table can be dropped by the using the following command.

SYNTAX for MS Access
DROP INDEX index_name ON table_name

SYNTAX for SQL SERVER
DROP INDEX table_name.index_name

SYNTAX for Oracle
DROP INDEX index_name

SYNTAX for MySQL
ALTER TABLE table_name DROP INDEX index_name