DROP INDEX

description

This statement is used to delete index from table
grammer:
    DROP INDEX index_name ON [db_name.]table_name;

keyword

DROP,INDEX