Query INFORMATION_SCHEMA.VIEWS : INFORMATION_SCHEMA « System « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. System
  3. INFORMATION_SCHEMA

Query INFORMATION_SCHEMA.VIEWS

 




3> SELECT top 10 TABLE_NAME, TABLE_SCHEMA
4> FROM INFORMATION_SCHEMA.VIEWS
5> GO
TABLE_NAME                                                                                                                       TABLE_SCHEMA

-------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------
---------------------------------------------------------
titleview                                                                                                                        dbo

vwProductList                                                                                                                    dbo

vV                                                                                                                               dbo


(3 rows affected)
1>








Related examples in the same category

1.INFORMATION_SCHEMA.TABLES
2.Another way to test for the existence of a table