SQL Server/T-SQL Tutorial/System Tables Views/sys.sql dependencies
Reporting on Database Views by joining sys.sql_dependencies, sys.views and sys.schemas
<source lang="sql">
4> 5> SELECT DISTINCT 6> s.name SchemaName, 7> v.name ViewName, 8> OBJECT_NAME(referenced_major_id) ReferencedObject 9> FROM sys.sql_dependencies d 10> INNER JOIN sys.views v ON 11> d.object_id = v.object_id 12> INNER JOIN sys.schemas s ON 13> v.schema_id = s.schema_id 14> ORDER BY s.name, v.name 15> GO SchemaName
ViewName ReferencedObject
---------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
(0 rows affected) 1></source>