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:
DROP INDEX name
Example:
DROP INDEX email_idx;