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
精彩评论