Reporting on Database Views by joining sys.views and sys.schemas : sys.schemas « System Tables Views « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Tables Views
3. sys.schemas

3>
4> SELECT s.name SchemaName,
5> v.name ViewName
6> FROM sys.views v
7> INNER JOIN sys.schemas s ON
8> v.schema_id = s.schema_id
9> ORDER BY s.name,
10> v.name
11> GO
SchemaName
         ViewName

------------------------------------------------------------------------------------------------------------------------
-------- ---------------------------------------------------------------------------------------------------------------
-----------------

(0 rows affected)
1>