DROP INDEX

version 11

DROP INDEX sql_name

The DROP INDEX command is used to remove an existing index named sql_name from a database. It cannot be used on indexes created for PRIMARY KEY or UNIQUE constraints.

Here is a simple example for removing an index:

   DROP INDEX ID_INDEX

CREATE INDEX.