How to remove unique key from mysql table

Question

I want to remove a unique key from my MySQL table. How can I remove that using the MySQL query?

I attempted this, though it is not working

alter table tbl_quiz_attempt_master drop unique key;

Can anyone help me with this?

Answer 1

All the keys are named, you should be using something like below:

ALTER TABLE tbl_quiz_attempt_master
  DROP INDEX index_name;

To drop the primary key you can use the following:

ALTER TABLE tbl_quiz_attempt_master
  DROP INDEX `PRIMARY`;

Are you interested to learn SQL in detail? Sign up for the SQL Training course by Intellipaat.

For more details on MySQL, refer to the below MySQL Tutorial video.