Show Forgein Keys in MySQL
Wednesday, November 25th, 2009Here 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;