SELECT
OBJECT_NAME(FC.parent_object_id) AS FROM_TABLE
, OBJECT_NAME(FC.referenced_object_id) AS TO_TABLE
, FROM_C.name AS FROM_COLUMN_NAME
, TO_C.name AS TO_COLUMN_NAME
, FK_OBJ.name AS FK_NAME
, FK_OBJ.create_date AS FK_CREATE_DATE
FROM
SYS.foreign_key_columns FC
INNER JOIN SYS.columns TO_C ON TO_C.object_id = FC.referenced_object_id AND TO_C.column_id = FC.referenced_column_id
INNER JOIN SYS.columns FROM_C ON FROM_C.object_id = FC.parent_object_id AND FROM_C.column_id = FC.parent_column_id
INNER JOIN SYS.objects FK_OBJ ON FK_OBJ.object_id = FC.constraint_object_id
ORDER BY
OBJECT_NAME(FROM_C.object_id)
'DB관련 > SQL' 카테고리의 다른 글
SqlServerCompactEdition (0) | 2014.10.20 |
---|---|
Table + Constraint + Index + Trigger 스크립팅 (0) | 2012.01.18 |
[SQL] TABLE 명세, 결과물은 HTML (0) | 2012.01.03 |
[SQL] Table 간단 명세 쿼리 (0) | 2012.01.03 |
[SQL] MS-SQL 특정 테이블이 사용하는 모든 프로시저 검색 쿼리 (0) | 2011.12.21 |