Subscribe
Nov 17, 2008 
In MySQL 5.0 it is possible to drop unqiue constraints but, the syntax is not incredibly intuitive.
alter table TABLE_NAME drop index UNIQUE_CONSTRAINT_NAME;
Code Ghar provides a more thorough description.
Tech Notes
Miscellaneous technology examples and notes
Nov 17, 2008 
1 Comment 
1 Comment
-
It’s also worth noting that
1) you must not use quotes of any kind around UNIQUE_CONSTRAINT_NAME
2) you can find the name of the constraint by entering at the mysql shell:
SHOW CREATE TABLE TABLE_NAME
…where TABLE_NAME is the name of the table containing the constraint.
Leave a Reply
-
About this blog
Tech Notes is a simple blog by Ryan Nitz providing technology analysis, research, reviews and notes.
