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
带加强色的那三个视图是最常用的。 哈哈 : )