DROP INDEX

Deletes the index in a table.

Syntax

DROP INDEX index_name ON table_name;