you can use the following script in order to find all the fk,pk relationship for specific table *DECLARE @tablename VARCHAR(100) SET @tablename='xxxxxxx' Select 'Referenced by FK table' AS Type, FK.TABLE_SCHEMA, FK.TABLE_NAME AS 'FK_TABLE_NAME' ,cu.COLUMN_NAME AS 'FK_ReferencingColumn',PK.TABLE_NAME AS 'PK_TABLE_NAME', ku.COLUMN_NAME AS 'PK ... More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.