deepu sankar deepu sankar - 1 year ago 81
MySQL Question

How to remove constraints from my MySQL table?

I want to remove constraints from my table. My query is:

ALTER TABLE `tbl_magazine_issue`
DROP CONSTRAINT `FK_tbl_magazine_issue_mst_users`

But I got an 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 'constraint
' at line 1

Answer Source

Mysql has a special syntax for dropping foreign key constraints:

ALTER TABLE tbl_magazine_issue
  DROP FOREIGN KEY FK_tbl_magazine_issue_mst_users
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download