SELECT 
    FK.Name AS ForeignKeyName,
    TP.NAME AS TableName,
    CP.NAME AS ColumnName,
    RFK.Name AS ReferencedTableName,
    CFK.NAME AS ReferencedColumnName
FROM 
    sys.foreign_keys FK
INNER JOIN 
    sys.tables TP ON FK.parent_object_id = TP.object_id
INNER JOIN 
    sys.tables RFK ON FK.referenced_object_id = RFK.object_id
INNER JOIN 
    sys.foreign_key_columns FKC ON FKC.constraint_object_id = FK.object_id
INNER JOIN 
    sys.columns CP ON FKC.parent_column_id = CP.column_id AND FKC.parent_object_id = CP.object_id
INNER JOIN 
    sys.columns CFK ON FKC.referenced_column_id = CFK.column_id AND FKC.referenced_object_id = CFK.object_id;