January 17, 2018 at 12:48 pm
Comments posted to this topic are about the item DataDictionarySelect
February 22, 2018 at 1:01 pm
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.
February 22, 2018 at 1:44 pm
Thank you for this script, I was just think that it would be really great to get this information out of my ERP database. Vendors think their developers know the tables we should know them too. I have been trying to create and modify reports trying to find the foreign keys, this will help me.
Thank you,
February 27, 2018 at 7:16 pm
Grasshopper, thank you! Precisely the feedback that's needed. I will post a correction soon.
February 27, 2018 at 7:19 pm
patrick.slesicki - Tuesday, February 27, 2018 7:16 PMGrasshopper, thank you! Precisely the feedback that's needed. I will post a correction soon.
Also, glad you found the script useful. I'd been looking for a quick dd solution for the longest time and decided to write it.
I just added the foreign key feature recently; again, thank you for the observation!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy