Check out example codes for "drop unique key from column mysql". It will help you in understanding the concepts better.

Code Example 1

ALTER TABLE Persons

DROP INDEX UC_Person;

Code Example 2

DROP INDEX index_name ON tbl_name

Code Example 3

ALTER TABLE tbl_quiz_attempt_master
  DROP INDEX `PRIMARY`;

Code Example 4

ALTER TABLE mytable DROP INDEX key_Name;

Code Example 5

ALTER TABLE tbl_name DROP INDEX index_name

Learn ReactJs, React Native from akashmittal.com