Sample Header Ad - 728x90

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