开发者

Using sys.dm_sql_referenced_entities to show on dependencies that are views

开发者 https://www.devze.com 2023-02-22 20:31 出处:网络
I use the following query to find dependencies on a view 开发者_Go百科SELECT referenced_entity_name,*FROM

I use the following query to find dependencies on a view

开发者_Go百科
    SELECT referenced_entity_name,*  FROM 
sys.dm_sql_referenced_entities ('dbo.WEB_ANALYSER', 'OBJECT')

This returns tables and views used in the View. I want the above query to only return dependencies that are views

Thanks


select referenced_entity_name, re.*
from sys.dm_sql_referenced_entities ('dbo.WEB_ANALYSER', 'OBJECT') as re
  inner join sys.views as sv
    on sv.name = re.referenced_entity_name
0

精彩评论

暂无评论...
验证码 换一张
取 消