Information_Schema View Listing

MSSQL INFORMATION_SCHEMA 视图详解

最新推荐文章于 2023-03-15 20:08:32 发布

原创最新推荐文章于 2023-03-15 20:08:32 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#schema #constraints #each #database #table #function

.Net 同时被 2 个专栏收录

75 篇文章

订阅专栏

SQL

6 篇文章

订阅专栏

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 


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