Pages

Monday, March 19, 2012

How to find Foreign Keys in MS SQL

Select SCHEMA_NAME(a.schema_id) 'SCHEMA_NAME'
,OBJECT_NAME(a.parent_object_id) as 'TABLE_NAME'
,OBJECT_NAME(a.referenced_object_id) as 'REFERENCE_TABLE_NAME'
,a.name as 'FOREIGN_KEY_NAME'
From sys.foreign_keys a