2020. 3. 25. 10:22
SQL SERVER
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 |