SQL DROP INDEX Statement

SQL DROP INDEX statement frees allocated memory and removes the index definition from the database information schema. Here are some syntaxes of DROP INDEX statement in common RDBMSs :

DROP INDEX statement in Oracle

DROP INDEX [<qualifier>.]<index_name>;

DROP INDEX statement in MS SQL Server

In MS SQL Server, you have to specify both the table name in which the indexed column is located and the index name.You can drop multiple indexes by one DROP INDEX statement; the index names must be seperated by a comma.

DROP INDEX <table_name>.<index_name> [,...]

DROP INDEX statement in MySQL

DROP INDEX index_name ON table_name