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
– Arman Feyzi, Commented Sep 30, 2020 at 10:53
Does this answer your question? How to remove constraints from my MySQL table? — GSerg
– GSerg, Commented Sep 30, 2020 at 11:02

Slava Rozhnev · Accepted Answer · 2020-09-30 11:12:17Z

2

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, 2020 at 11:12

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

osumatu · Accepted Answer · 2020-09-30 11:12:12Z

1

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, 2020 at 11:12

osumatu

4422 gold badges8 silver badges25 bronze badges

Collectives™ on Stack Overflow

Syntax error in MySQL 5.7 for use CONSTRAINT

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related