Syntax error in MySQL 5.7 for use CONSTRAINT

Question

I try to fix some error in Jira as mention in this page but when I try to run an SQL query, I got the below error:

ERROR 1064 (42000): 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_ao_8542f1_ifj_obj_attr_val_object_attribute_id' at line 1

My Query is:

ALTER TABLE AO_8542F1_IFJ_OBJ_ATTR_VAL 
DROP CONSTRAINT `fk_ao_8542f1_ifj_obj_attr_val_object_attribute_id`

How I can fix this Query? I use MySQL version 5.7

I want to use the "Insight" plugin in Jira and those tables create by plugin — Arman Feyzi, Sep 30 '20 at 10:53
Does this answer your question? [How to remove constraints from my MySQL table?](https://stackoverflow.com/questions/14122031/how-to-remove-constraints-from-my-mysql-table) — GSerg, Sep 30 '20 at 11:02

score 1 · Answer 1 · answered Sep 30 '20 at 11:12

1

Drop MySQL foreign key constraints To drop a foreign key constraint, you use the ALTER TABLE statement:

ALTER TABLE table_name 
DROP FOREIGN KEY constraint_name;

answered Sep 30 '20 at 11:12

Slava Rozhnev

8,085
6
21
35

score 0 · Answer 2 · answered Sep 30 '20 at 11:12

0

Judging by the name of the constraint, I believe it's a foreign key and MySQL has a different approach to drop foreign keys:

ALTER TABLE AO_8542F1_IFJ_OBJ_ATTR_VAL
DROP FOREIGN KEY `fk_ao_8542f1_ifj_obj_attr_val_object_attribute_id`

answered Sep 30 '20 at 11:12

osumatu

398
1
5
21

Syntax error in MySQL 5.7 for use CONSTRAINT

2 Answers2