INFORMATION SCHEMA VIEW HELP IN SQL SERVER 2005

INFORMATION_SCHEMA views are SQL-92 ANSI standards which conforms views with database metadata.

We can use SELECT statements to get their contents.

select * from Information_Schema.Check_Constraints

select * from Information_Schema.Column_Domain_Usage

select * from Information_Schema.Column_Privileges

select * from Information_Schema.Columns

select * from Information_Schema.Constraint_Column_Usage

select * from Information_Schema.Constraint_Table_Usage

select * from Information_Schema.Domain_Constraints

select * from Information_Schema.Domains

select * from Information_Schema.Key_Column_Usage

select * from Information_Schema.Parameters

select * from Information_Schema.Referential_Constraints

select * from Information_Schema.Routine_Columns

select * from Information_Schema.Routines

select * from Information_Schema.Schemata

select * from Information_Schema.Table_Constraints

select * from Information_Schema.Table_Privileges

select * from Information_Schema.Tables

select * from Information_Schema.Views

select * from Information_Schema.View_Column_Usage

select * from Information_Schema.View_Table_Usage

I got this information from an excellent blogger.Please spread the knowledge.

Pawan Kumar
Pawankkmr@hotmail.com

Advertisements