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