Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- ------------------
- -- FIND FK TO A TABLE
- 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>';
- -- -------------------
- -- FIND FK TO A 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_COLUMN_NAME = '<column>';
Add Comment
Please, Sign In to add comment