How to delete unique constraint in Mysql?

Question

my code

alter table mytable drop unique constraint uk_mytable;

but shows the following error...

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unique constraint username' at line 1"

http://stackoverflow.com/questions/3487691/dropping-unique-constraint-from-mysql-table — Damodaran, Jan 23 '14 at 11:24

score 1 · Accepted Answer · answered Jan 23 '14 at 11:18

1

Try this

alter table mytable drop uk_mytable;

answered Jan 23 '14 at 11:18

Abdul Manaf

4,768
3
27
34

How to delete unique constraint in Mysql?

1 Answers1