MySQL

Show foreign keys for a given table

https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column

SELECT

 TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME

FROM

 INFORMATION_SCHEMA.KEY_COLUMN_USAGE

WHERE

 REFERENCED_TABLE_SCHEMA = 'database' AND
 REFERENCED_TABLE_NAME = 'table';

Links

• gh-ost: GitHub’s online schema migration tool for MySQL
• Designing Highly Scalable Database Architectures - Not specific to MySQL.