How to remove unique key from mysql table

Question

I need to remove a unique key from my mysql table. How can remove that using mysql query.

I tried this but it is not working

alter table tbl_quiz_attempt_master drop unique key; 

Please help me

Thanks

Answer 1

All keys are named, you should use something like this -

ALTER TABLE tbl_quiz_attempt_master   DROP INDEX index_name; 

To drop primary key use this one -

ALTER TABLE tbl_quiz_attempt_master   DROP INDEX `PRIMARY`; 

ALTER TABLE Syntax.

Answer 2

First you need to know the exact name of the INDEX (Unique key in this case) to delete or update it.
INDEX names are usually same as column names. In case of more than one INDEX applied on a column, MySQL automatically suffixes numbering to the column names to create unique INDEX names.

For example if 2 indexes are applied on a column named customer_id

1. The first index will be named as customer_id itself.
2. The second index will be names as customer_id_2 and so on.

To know the name of the index you want to delete or update

SHOW INDEX FROM <table_name> 

as suggested by @Amr

To delete an index

ALTER TABLE <table_name> DROP INDEX <index_name>;