Check out example codes for "remove unique key from a table". It will help you in understanding the concepts better.

Code Example 1

ALTER TABLE mytable DROP INDEX key_Name;

Code Example 2

DROP INDEX index_name ON tbl_name

Code Example 3

example: alter table DropIndex drop index BookId ;

Learn ReactJs, React Native from akashmittal.com