728x90
1 2 3 4 5 6 7 8 9 10 11 12 | SELECT CAST(F.NAME AS VARCHAR(255)) AS FOREIGN_KEY_NAME , CAST(C.NAME AS VARCHAR(255)) AS FOREIGN_TABLE , CAST(FC.NAME AS VARCHAR(255)) AS FOREIGN_COLUMN , CAST(P.NAME AS VARCHAR(255)) AS PARENT_TABLE , CAST(RC.NAME AS VARCHAR(255)) AS PARENT_COLUMN FROM SYSOBJECTS F INNER JOIN SYSOBJECTS C ON F.PARENT_OBJ = C.ID INNER JOIN SYSREFERENCES R ON F.ID = R.CONSTID INNER JOIN SYSOBJECTS P ON R.RKEYID = P.ID INNER JOIN SYSCOLUMNS RC ON R.RKEYID = RC.ID AND R.RKEY1 = RC.COLID INNER JOIN SYSCOLUMNS FC ON R.FKEYID = FC.ID AND R.FKEY1 = FC.COLID WHERE F.TYPE = 'F' | cs |
728x90
'[2]SW Development Note' 카테고리의 다른 글
T-SQL 실습 스크립트 (0) | 2021.10.07 |
---|---|
nmap 명령어/사용법 (0) | 2021.08.02 |
MSSQL 구간 번호 구하기. (0) | 2021.08.02 |
특정 필드의 정수 값으로 row 분할하기.[MSSQL] (0) | 2021.08.02 |
Flutter (0) | 2020.12.02 |
댓글