• I'm not sure if I understood what you are looking for, but if you want to know which fk column of a table references to which other object this should be the solution:

    SELECT OBJECT_NAME(fk.referenced_object_id) referenced_object,

    OBJECT_NAME(fk.parent_object_id) fk_object,

    ref_col.name referenced_column,

    fk_col.name fk_column,

    fk.name fk_name

    FROM sys.foreign_keys fk

    JOIN sys.foreign_key_columns fkc ON fk.object_id = fkc.constraint_object_id

    JOIN sys.columns fk_col ON fk.parent_object_id = fk_col.object_id AND fkc.parent_column_id = fk_col.column_id

    JOIN sys.columns ref_col ON fk.referenced_object_id = ref_col.object_id AND fkc.referenced_column_id = ref_col.column_id

    Greets

    Flo