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