Information_Schema View Listing

List of all MSSQL INFORMATION_SCHEMA views:

INFORMATION_SCHEMA.CHECK_CONSTRAINTS  Holds information about constraints in the database 

INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE  Identifies which columns in which tables are user-defined datatypes 

INFORMATION_SCHEMA.COLUMN_PRIVILEGES  Has one row for each column level permission granted to or by the current user 

INFORMATION_SCHEMA.COLUMNS  Lists one row for each column in each table or view in the database 

INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE  Lists one row for each column that has a constraint defined on it 

INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE  Lists one row for each table that has a constraint defined on it 

INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS  Lists the user-defined datatypes that have rules bound to them 

INFORMATION_SCHEMA.DOMAINS  Lists the user-defined datatypes 

INFORMATION_SCHEMA.KEY_COLUMN_USAGE  Lists one row for each column that's defined as a key 

INFORMATION_SCHEMA.PARAMETERS  Lists one row for each parameter in a stored procedure or user-defined function 

INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS  Lists one row for each foreign constraint 

INFORMATION_SCHEMA.ROUTINES  Lists one row for each stored procedure or user-defined function 

INFORMATION_SCHEMA.ROUTINE_COLUMNS  Contains one row for each column returned by any table-valued functions 

INFORMATION_SCHEMA.SCHEMATA  Contains one row for each database 

INFORMATION_SCHEMA.TABLE_CONSTRAINTS  Lists one row for each constraint defined in the current database 

INFORMATION_SCHEMA.TABLE_PRIVILEGES  Has one row for each table level permission granted to or by the current user 

INFORMATION_SCHEMA.TABLES  Lists one row for each table or view in the current database 

INFORMATION_SCHEMA.VIEW_COLUMN_USAGE  Lists one row for each column in a view including the base table of the column where possible 

INFORMATION_SCHEMA.VIEW_TABLE_USAGE  Lists one row for each table used in a view 

INFORMATION_SCHEMA.VIEWS Lists one row for each view 


带加强色的那三个视图是最常用的。 哈哈 : )