SELECT f.name, OBJECT_NAME(f.parent_object_id) TableName, COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN sys.tables t
ON t.OBJECT_ID = fc.referenced_object_id
WHERE OBJECT_NAME (f.referenced_object_id) = '테이블명'
출처: https://hackhyun.tistory.com/250 [전산이야기]
'SQL SERVER' 카테고리의 다른 글
Extended Event Data Table 로 가져오기 (0) | 2020.10.13 |
---|---|
SQL Formatter (0) | 2020.06.05 |
sql server 2012 Recommended Trace flag (0) | 2020.02.13 |
Oracle Client 업그레이드 (0) | 2020.01.16 |
sql server default 제약조건 조회SQL (0) | 2020.01.15 |