Usage and Examples of SQL DROP INDEX Keyword

SQL Keyword Reference

DROP INDEX (Delete Index)

The DROP INDEX command is used to delete indexes from a table.

MS Access：

DROP INDEX index_name ON table_name;

SQL Server：

DROP INDEX table_name.index_name;

DB2 / Oracle：

DROP INDEX index_name;

MySQL：

ALTER TABLE DROP INDEX ;

SQL Keyword Reference