MySQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
== 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 == | == Links == | ||
Revision as of 13:23, 10 June 2019
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.