SQL Server/T-SQL Tutorial/System Tables Views/sys.sql dependencies

Материал из SQL эксперт
Перейти к: навигация, поиск

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>