|
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>
|