MySQL :: MySQL 8.4 参考手册 :: 28.3.1 INFORMATION

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.3 INFORMATION_SCHEMA 总表 / 28.3.1 INFORMATION_SCHEMA 通用表参考

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 96%

28.3.1 INFORMATION_SCHEMA 通用表参考28.3.1 INFORMATION_SCHEMA General Table Reference

下表总结了 INFORMATION_SCHEMA 通用表。有关更多详细信息，请参阅各个表的描述。The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions.

表 28.2 INFORMATION_SCHEMA 通用表Table 28.2 INFORMATION_SCHEMA General Tables

表名Table Name	说明Description
`ADMINISTRABLE_ROLE_AUTHORIZATIONSADMINISTRABLE_ROLE_AUTHORIZATIONS`	当前用户或角色可授予的用户或角色Grantable users or roles for current user or role
`APPLICABLE_ROLESAPPLICABLE_ROLES`	当前用户的适用角色Applicable roles for current user
`CHARACTER_SETS`	可用字符集Available character sets
`CHECK_CONSTRAINTS`	表和列的 CHECK 约束Table and column CHECK constraints
`COLLATION_CHARACTER_SET_APPLICABILITY`	每个排序规则适用的字符集Character set applicable to each collation
`COLLATIONS`	每个字符集的排序规则Collations for each character set
`COLUMN_PRIVILEGESCOLUMN_PRIVILEGES`	列上定义的权限Privileges defined on columns
`COLUMN_STATISTICSCOLUMN_STATISTICS`	列值的直方图统计Histogram statistics for column values
`COLUMNSCOLUMNS`	每个表的列Columns in each table
`COLUMNS_EXTENSIONSCOLUMNS_EXTENSIONS`	主存储和次存储引擎的列属性Column attributes for primary and secondary storage engines
`ENABLED_ROLESENABLED_ROLES`	当前会话中启用的角色Roles enabled within current session
`ENGINESENGINES`	存储引擎属性Storage engine properties
`EVENTSEVENTS`	事件管理器事件Event Manager events
`FILESFILES`	存储表空间数据的文件Files that store tablespace data
`KEY_COLUMN_USAGEKEY_COLUMN_USAGE`	哪些键列有约束Which key columns have constraints
`KEYWORDSKEYWORDS`	MySQL 关键字MySQL keywords
`ndb_transid_mysql_connection_mapndb_transid_mysql_connection_map`	NDB 事务信息NDB transaction information
`OPTIMIZER_TRACEOPTIMIZER_TRACE`	优化器跟踪活动产生的信息Information produced by optimizer trace activity
`PARAMETERSPARAMETERS`	存储例程参数和存储函数返回值Stored routine parameters and stored function return values
`PARTITIONSPARTITIONS`	表分区信息Table partition information
`PLUGINSPLUGINS`	插件信息Plugin information
`PROCESSLISTPROCESSLIST`	当前执行线程的信息Information about currently executing threads
`PROFILINGPROFILING`	语句性能分析信息Statement profiling information
`REFERENTIAL_CONSTRAINTSREFERENTIAL_CONSTRAINTS`	外键信息Foreign key information
`RESOURCE_GROUPSRESOURCE_GROUPS`	资源组信息Resource group information
`ROLE_COLUMN_GRANTSROLE_COLUMN_GRANTS`	当前启用角色可用或授予的角色列权限Column privileges for roles available to or granted by currently enabled roles
`ROLE_ROUTINE_GRANTSROLE_ROUTINE_GRANTS`	当前启用角色可用或授予的角色例程权限Routine privileges for roles available to or granted by currently enabled roles
`ROLE_TABLE_GRANTSROLE_TABLE_GRANTS`	当前启用角色可用或授予的角色表权限Table privileges for roles available to or granted by currently enabled roles
`ROUTINESROUTINES`	存储例程信息Stored routine information
`SCHEMA_PRIVILEGESSCHEMA_PRIVILEGES`	在架构上定义的权限Privileges defined on schemas
`SCHEMATASCHEMATA`	架构信息Schema information
`SCHEMATA_EXTENSIONSSCHEMATA_EXTENSIONS`	模式选项Schema options
`ST_GEOMETRY_COLUMNSST_GEOMETRY_COLUMNS`	每个存储空间数据的表中的列Columns in each table that store spatial data
`ST_SPATIAL_REFERENCE_SYSTEMSST_SPATIAL_REFERENCE_SYSTEMS`	可用的空间参考系统Available spatial reference systems
`ST_UNITS_OF_MEASUREST_UNITS_OF_MEASURE`	ST_Distance() 的可接受单位Acceptable units for ST_Distance()
`STATISTICSSTATISTICS`	表索引统计信息Table index statistics
`TABLE_CONSTRAINTSTABLE_CONSTRAINTS`	哪些表有约束Which tables have constraints
`TABLE_CONSTRAINTS_EXTENSIONSTABLE_CONSTRAINTS_EXTENSIONS`	主存储和辅助存储引擎的表约束属性Table constraint attributes for primary and secondary storage engines
`TABLE_PRIVILEGESTABLE_PRIVILEGES`	表上定义的权限Privileges defined on tables
`TABLESTABLES`	表信息Table information
`TABLES_EXTENSIONSTABLES_EXTENSIONS`	主存储引擎和次存储引擎的表属性Table attributes for primary and secondary storage engines
`TABLESPACES_EXTENSIONSTABLESPACES_EXTENSIONS`	主存储引擎的表空间属性Tablespace attributes for primary storage engines
`TRIGGERSTRIGGERS`	触发器信息Trigger information
`USER_ATTRIBUTESUSER_ATTRIBUTES`	用户评论和属性User comments and attributes
`USER_PRIVILEGESUSER_PRIVILEGES`	按用户全局定义的权限Privileges defined globally per user
`VIEW_ROUTINE_USAGEVIEW_ROUTINE_USAGE`	视图中使用的存储函数Stored functions used in views
`VIEW_TABLE_USAGEVIEW_TABLE_USAGE`	视图中使用的表和视图Tables and views used in views
`VIEWSVIEWS`	视图信息View information

首页上一级下一节