• 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.