

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
- 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 can we get only unique values of a column in MySQL result set?
- How can we apply UNIQUE constraint to the field of an existing MySQL table?
- How can we remove a selected row from a JTable in Java?
- How to remove unique characters within strings in R?
- 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?
Advertisements