ALTER TABLE mytable DROP INDEX key_Name;
ALTER TABLE Persons DROP INDEX UC_Person;
ALTER TABLE tbl_name DROP INDEX index_name
DROP INDEX index_name ON tbl_name
ALTER TABLE tbl_quiz_attempt_master DROP INDEX `PRIMARY`;