How to check foreign keys related to a table
60
votes
4
answers
155953
views
How to see foreign keys related to a table in MySql?
**Background** : I wanted to drop a table in MySql which has a foreign key constraint. When I do it I get this:
Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails
>How can I drop foreign keys related to the table leaving others.
Asked by Mr.X
(921 rep)
May 24, 2015, 03:48 PM
Last activity: Dec 8, 2022, 10:13 AM
Last activity: Dec 8, 2022, 10:13 AM