Coderguy’s Blog

Here is a handy query I found the mysql reference manual for how to see all the foreign keys in a database:

SELECT ke.referenced_table_name parent, ke.table_name child, ke.constraint_name
FROM information_schema.KEY_COLUMN_USAGE ke
WHERE ke.referenced_table_name IS NOT NULL
ORDER BY ke.referenced_table_name;

This entry was posted on Wednesday, November 25th, 2009 at 10:20 am and is filed under MySQL, Quick Tip. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.