Dropping Unique constraint from MySQL table

by

A unique constraint is also an index.

First use SHOW INDEX FROM tbl_name to find out the name of the index. The name of the index is stored in the column called key_name in the results of that query.

Then you can use DROP INDEX:

DROP INDEX index_name ON tbl_name

or the ALTER TABLE syntax:

ALTER TABLE tbl_name DROP INDEX index_name

More Related Contents:

  1. How to store Emoji Character in MySQL Database
  2. MySQL: Quick breakdown of the types of joins [duplicate]
  3. Any way to select without causing locking in MySQL?
  4. Log all queries in mysql
  5. Truncate all tables in a MySQL database in one command?
  6. Cast from VARCHAR to INT – MySQL
  7. Find distance between two points using latitude and longitude in mysql
  8. How to convert result table to JSON array in MySQL
  9. Adding multiple columns AFTER a specific column in MySQL
  10. MySQL varchar index length
  11. DOUBLE vs DECIMAL in MySQL
  12. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  13. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  14. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  15. Terminating idle mysql connections
  16. What is MySQL’s default ON DELETE behavior?
  17. Select from one table where not in another
  18. How do I setup ASP.NET MVC 2 with MySQL?
  19. mysql DECLARE WHILE outside stored procedure how?
  20. SELECT query return 1 row from each group
  21. MySql Single Table, Select last 7 days and include empty rows
  22. How can I check MySQL engine type for a specific table?
  23. mysql SQL: specific item to be first and then to sort the rest of the items
  24. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  25. When is a timestamp (auto) updated?
  26. Should I normalize my DB or not?
  27. ALTER TABLE ADD COLUMN takes a long time
  28. Creating MYSQL Procedure in Laravel 4 Migrations
  29. MySQL: Computed Column
  30. Mysql server does not support 4-byte encoded utf8 characters

Leave a Comment