A DROP INDEX command allows us to drop the existing index. If the index was not given a name during creation, the index name is <table_name>_<column_name>_idx.
Syntax:
|
1 |
DROP INDEX name |
Example:
|
1 |
DROP INDEX email_idx; |