SELECT
F.NAME AS FOREIGNKEY,
OBJECT_NAME(F.PARENT_OBJECT_ID) AS TABLENAME,
COL_NAME(FC.PARENT_OBJECT_ID,
FC.PARENT_COLUMN_ID) AS COLUMNNAME,
OBJECT_NAME (F.REFERENCED_OBJECT_ID) AS REFERENCETABLENAME,
COL_NAME(FC.REFERENCED_OBJECT_ID,
FC.REFERENCED_COLUMN_ID) AS REFERENCECOLUMNNAME
FROM
SYS.FOREIGN_KEYS AS F
INNER JOIN SYS.FOREIGN_KEY_COLUMNS AS FC ON F.OBJECT_ID = FC.CONSTRAINT_OBJECT_ID
ORDER BY COL_NAME(FC.REFERENCED_OBJECT_ID,FC.REFERENCED_COLUMN_ID)
F.NAME AS FOREIGNKEY,
OBJECT_NAME(F.PARENT_OBJECT_ID) AS TABLENAME,
COL_NAME(FC.PARENT_OBJECT_ID,
FC.PARENT_COLUMN_ID) AS COLUMNNAME,
OBJECT_NAME (F.REFERENCED_OBJECT_ID) AS REFERENCETABLENAME,
COL_NAME(FC.REFERENCED_OBJECT_ID,
FC.REFERENCED_COLUMN_ID) AS REFERENCECOLUMNNAME
FROM
SYS.FOREIGN_KEYS AS F
INNER JOIN SYS.FOREIGN_KEY_COLUMNS AS FC ON F.OBJECT_ID = FC.CONSTRAINT_OBJECT_ID
ORDER BY COL_NAME(FC.REFERENCED_OBJECT_ID,FC.REFERENCED_COLUMN_ID)
No comments:
Post a Comment