DenkzeitWiki

Information Schema

Metadata on schemata

• Information Schema Views and Object Properties
  
• Using the Information Schema Views

if EXISTS (select * from INFORMATION_SCHEMA.tables where table_name = 'Table8')
    Select Top 1 * from Table8

• Where INFORMATION_SCHEMA is the owner (SQLServer-speak) or schema (ANSI-SQL-speak) of the table 'tables'...
  
• Comparing Tables -- doing some DBSchemaDiffing...!
  
• System Tables

SQLServer

• Information Schema Views from the Transact-SQL Reference
  
• Problem Solving With Information Schema Columns
  
• A Primer on INFORMATION_SCHEMA Views in SQL Server 2000