Skip to content

Instantly share code, notes, and snippets.

@midnite81
Last active June 20, 2020 23:07
Show Gist options
  • Save midnite81/9dc1e8e6b3a9c43121e7b8a15c4b1098 to your computer and use it in GitHub Desktop.
Save midnite81/9dc1e8e6b3a9c43121e7b8a15c4b1098 to your computer and use it in GitHub Desktop.
Gets foreign keys for a column
SET @tableName = '<table_name>';
SET @columnName = '<column_name>';
SELECT table_name, column_name, referenced_table_name, referenced_column_name
FROM information_schema.key_column_usage
WHERE table_name = @tableName AND column_name = @columnName;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment