Skip to content

Instantly share code, notes, and snippets.

@iancanderson

iancanderson/get_foreign_keys.sql

Created October 10, 2011 19:01
Show Gist options
  • Save iancanderson/1276198 to your computer and use it in GitHub Desktop.
Save iancanderson/1276198 to your computer and use it in GitHub Desktop.
Download ZIP
Get foreign key columns names of SQL SERVER tables
Raw
get_foreign_keys.sql
select pk.TABLE_NAME, c.COLUMN_NAME as 'foreign_key'
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,
INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
where
CONSTRAINT_TYPE = 'PRIMARY KEY'
and c.TABLE_NAME = pk.TABLE_NAME
and c.CONSTRAINT_NAME = pk.CONSTRAINT_NAME
order by pk.TABLE_NAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment