Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Reporting on Database Views by joining sys views and 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>