开发者

Using sys.dm_sql_referenced_entities to show on dependencies that are views

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜