ALTER TABLE tbl_name DROP INDEX index_name
ALTER TABLE Persons DROP INDEX UC_Person;
DROP INDEX index_name ON tbl_name