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