특정 테이블의 참조제약 정보 확인 > db

출처 : http://www.sqlservercentral.com

내용 : 간단히 테이블만을 Where절에 지정해 참조 제약을 즉각적으로 확인하는 샘플 입니다.

도움 되시길 바랍니다.

/*
Use where clause to check for a specific table

Mohit Nayyar
*/

select s1.name as 'BaseTable', c1.name as 'BaseColumn (PK)',
s2.name 'TargetTable', c2.name as 'TargetColumn (FK)'
from sysReferences sr
join sysobjects s1 on (sr.rkeyid=s1.id)
join sysobjects s2 on (sr.fkeyid=s2.id)
join syscolumns c1 on (s1.id=c1.id and sr.rkey1=c1.colid)
join syscolumns c2 on (s2.id=c2.id and sr.fkey1=c2.colid)
--where sr.rkeyid=object_id('TableName')
order by s1.name, s2.name, c1.name, c2.name