Information_schema.views : Information_schema « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. Information_schema
The Information_schema.views view contains one row for each view in the current database accessible by the user.

7>
8> select top 10 * from Information_schema.views;
9>








26.14.Information_schema
26.14.1.select top 10 * from Information_schema.columns
26.14.2.Information_schema.views
26.14.3.Information_schema.tables
26.14.4.System views INFORMATION_SCHEMA
26.14.5.obtain metadata about database objects.
26.14.6.SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TestTable'
26.14.7.Match a table name in tempdb.INFORMATION_SCHEMA.TABLES
26.14.8.Query tempdb.INFORMATION_SCHEMA.TABLES
26.14.9.A script that creates a summary of the tables in a database
26.14.10.Check the view existance