How to remove constraints from my MySQL table?

by

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:

#1064 – 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 FK_tbl_magazine_issue_mst_users‘ at line 1

11 Answers
11

Leave a Comment