Command
DROP INDEX indexname;
Explanation
Drops an existing index from the current database.
Examples
Drop index on email column
DROP INDEX idx_users_email;
DROP INDEX indexname;
Drops an existing index from the current database.
Drop index on email column
DROP INDEX idx_users_email;