MySQL Lists: mysql: Re: Algorithm for resolving foreign key dependencies?

MySQL Lists: mysql: Re: Algorithm for resolving foreign key dependencies?: "SELECT c.table_schema,u.table_name,u.column_name,u.referenced_column_name
FROM information_schema.table_constraints AS c
INNER JOIN information_schema.key_column_usage AS u
USING( constraint_schema, constraint_name )
WHERE c.constraint_type = 'FOREIGN KEY'
AND u.referenced_table_schema='db'
AND u.referenced_table_name = 'tbl'
ORDER BY c.table_schema,u.table_name;"

'via Blog this'