SELECT OBJECT_NAME (FK.referenced_object_id) 'Referenced Table',OBJECT_NAME(FK.parent_object_id) 'Referring Table',FK.name 'Foreign Key',COL_NAME(FK.referenced_object_id, FKC.referenced_column_id) 'Referenced Column',COL_NAME(FK.parent_object_id,FKC.parent_column_id) 'Referring Column'FROM sys.foreign_keys AS FKINNER JOIN sys.foreign_key_columns AS FKCON FKC.constraint_object_id = FK.OBJECT_IDWHERE OBJECT_NAME (FK.referenced_object_id) = 'Enter Table Name'
No comments:
Post a Comment