Dropping Unique constraint from MySQL table

Question

How to drop the "Unique Key Constraint" on a column of a MySQL table using the phpMyAdmin?

Answer 1

A unique constraint is also an index.

First, use SHOW INDEX FROM tbl_name to determine the name of the index. The name of the index will be stored in the column called the "key_name" in the results of the query.

Then you can use the DROP INDEX:

DROP INDEX index_name ON tbl_name

or you can use the ALTER TABLE syntax:

ALTER TABLE tbl_name DROP INDEX index_name

Sign up for this Intellipaat's SQL Course fast, to Learn SQL concepts in detail and get certified.