DROP-INDEX
DROP-INDEXβ
Nameβ
DROP INDEX
Descriptionβ
This statement is used to delete the index of the specified name from a table. grammar:
DROP INDEX [IF EXISTS] index_name ON [db_name.]table_name;
Exampleβ
Delete the index
DROP INDEX [IF NOT EXISTS] index_name ON table1 ;
Keywordsβ
DROP, INDEX