Query sys.views : sys.views « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.views
4> SELECT top 10 name, schema_id
5> FROM sys.views
6> GO
name                                                                                                                             schema_id
-------------------------------------------------------------------------------------------------------------------------------- -----------
titleview                                                                                                                                  1
vwProductList                                                                                                                              1
vV                                                                                                                                         1

(3 rows affected)








27.21.sys.views
27.21.1.Reporting on Database Views by joining sys.columns and sys.views
27.21.2.Query sys.views
27.21.3.Check a view against sys.views