SELECT d.referencing_id,
QUOTENAME(s.name),
QUOTENAME(o.name),
QUOTENAME(d.referenced_ database_name),
QUOTENAME(d.referenced_schema_ name),
QUOTENAME(d.referenced_entity_ name),
d.referenced_id,
o.type_desc
FROM sys.sql_expression_ dependencies AS d
INNER JOIN sys.objects AS o ON d.referencing_id = o.[object_id]
INNER JOIN sys.schemas AS s ON o.[schema_id] = s.[schema_id]
No comments:
Post a Comment