SELECT DISTINCT t.name
[TableName], p.name
[ProcedureName]
FROM sys.objects t
LEFT JOIN sys.sql_dependencies d ON
d.referenced_major_id
= t.object_id
LEFT JOIN sys.objects p ON
p.object_id = d.object_id
WHERE t.type = 'u'
and t.name like '%tbl_Order%'
No comments:
Post a Comment