Skip to content

Instantly share code, notes, and snippets.

@ppazos

ppazos/get_fks_for_table.sql

Created April 12, 2024 04:18
Show Gist options
  • Save ppazos/a833415be92afdf1e594dd17e39d0cf7 to your computer and use it in GitHub Desktop.
Save ppazos/a833415be92afdf1e594dd17e39d0cf7 to your computer and use it in GitHub Desktop.
Download ZIP
Gets all the FKs that points to a given table
Raw
get_fks_for_table.sql
SELECT
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_SCHEMA = (SELECT DATABASE()) AND
REFERENCED_TABLE_NAME = '$TABLE_NAME'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment