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
