MySQL: Script to find Source and Destination of All Foreign Key Constraint

In this post, I am sharing a script to find the list of Foreign Keys with the source and destination table information of a MySQL Database.

Using below script you can easily find all foreign keys of a MySQL Database and its very useful for Database Architect for finding different references of foreign keys.

I am finding all Foreign Key references using INFORMATION_SCHEMA.KEY_COLUMN_USAGE.

Below is a script:

1 2 3 4 5 6 7

SELECT   referenced_table_name AS ParentTable   ,table_name AS ChildTable   ,constraint_name AS ConstraintName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE referenced_table_name IS NOT NULL ORDER BY referenced_table_name;