The ForeignKeySource displays the table of the foreign key but not use the column name form that table. ,ForeignKeySource = ISNULL
(
(
SELECT TOP (1) QUOTENAME(ss.name) + '.' + QUOTENAME(so.name) + '.' + QUOTENAME(c.name)
FROM sys.foreign_keys AS fk
JOIN sys.foreign_key_columns AS fkc
ON fk.object_id = fkc.constraint_object_id
JOIN sys.objects AS so
ON fkc.referenced_object_id = so.object_id
JOIN sys.schemas AS ss
ON so.schema_id = ss.schema_id
WHERE
fkc.parent_object_id = c.object_id
AND fkc.parent_column_id = c.column_id
)
,''
)
Alias c is for the column being displayed in the ColumnName column.