Day: February 4, 2019

Select views that don’t reference other views in SQL Server

4 February, 2019 Roel van Lisdonk 0 Comments Uncategorized 12:24

   -- Select views that don't reference other views. select         s.[name] ,       v.[name] from    sys.views v join    sys.schemas s on v.schema_id = s.schema_id where   v.object_id not in (     select distinct                 r.referenced_id     from        sys.dm_sql_referenced_entities (s.[name] + '.' + v.[name], 'OBJECT') r…

Read More

Select views that reference other views in SQL Server

4 February, 2019 Roel van Lisdonk 0 Comments Uncategorized 12:22

 -- Select views that reference other views. select distinct             s.[name] ,           v.[name] ,           r.referenced_schema_name ,           r.referenced_entity_name from        sys.views v join        sys.schemas s on v.schema_id = s.schema_id cross apply sys.dm_sql_referenced_entities (s.[name] + '.' + v.[name], 'OBJECT') r join        sys.objects o on r.referenced_id…

Read More