DROP INDEX

Drops an index object from the database.

Syntax:

DROP INDEX [ IF EXISTS ] index-name