/* Show all foreign key references (table relationships) */ 

SELECT table_name, column_name, constraint_name as REF_NAME, 
       referenced_table_name, referenced_column_name
FROM   information_schema.key_column_usage
WHERE  referenced_table_name IS NOT NULL;