How can we remove multicolumn UNIQUE indexes?

Multicolumn UNIQUE indexes can also be removed in the same as we remove UNIQUE constraint from the table.

Example

In this example, with the following query we have removed the multicolumn UNIQUE indexes on table ‘employee’ −

mysql> DROP index id_fname_lname on employee;
Query OK, 0 rows affected (0.30 sec)
Records: 0 Duplicates: 0 Warnings: 0

The removal of UNIQUE indexes can be observed from the result sets of the following query −

mysql> show index from employee;
Empty set (0.00 sec)

mysql> describe employee;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| empid      | int(11)     | YES  |     | NULL    |       |
| first_name | varchar(20) | YES  |     | NULL    |       |
| last_name  | varchar(20) | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.08 sec)

Samual Sam

Published on 16-Feb-2018 13:30:39

• Related Questions & Answers
• How can we create multicolumn UNIQUE indexes?
• How can we check the indexes created by a UNIQUE constraint on a MySQL table?
• How can we remove corruption from India?
• How can we drop UNIQUE constraint from a MySQL table?
• How can we remove a column from MySQL table?
• How can we get all the unique rows in MySQL result set?
• Can we remove _id from MongoDB query result?
• Remove unique key from MySQL table?
• Can we remove a primary key from MySQL table?
• How to remove unique characters within strings in R?
• How can we apply UNIQUE constraint to the field of an existing MySQL table?
• How can we get only unique values of a column in MySQL result set?
• How can we remove a selected row from a JTable in Java?
• How can we count a number of unique values in a column in MySQL table?
• Can we remove the Title Bar of a Frame in Java?