MySQL | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

MySQL

How to destroy a foreign key constraint?

24th Apr 2022, 1:08 AM
Zhilan Awat
Zhilan Awat - avatar
2 Answers
+ 3
-- Hope this link helps you SQL FOREIGN KEY Constraint https://www.w3schools.com/sql/sql_foreignkey.asp DROP a FOREIGN KEY Constraint To drop a FOREIGN KEY constraint, use the following SQL: MySQL: ALTER TABLE Orders DROP FOREIGN KEY FK_PersonOrder;
24th Apr 2022, 1:29 AM
SoloProg
SoloProg - avatar
+ 1
Zhilan Awat try this 👇👇👇 ALTER TABLE TABLE_NAME DROP CONSTRAINT FOREIGN_KEY_NAME
24th Apr 2022, 1:23 AM
NonStop CODING
NonStop CODING - avatar