Mega Code Archive

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>