MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
The following table summarizes
INFORMATION_SCHEMA
general tables. For greater
detail, see the individual table descriptions.
Table 26.2 INFORMATION_SCHEMA General Tables
Table Name | Description | Introduced |
---|---|---|
ADMINISTRABLE_ROLE_AUTHORIZATIONS |
Grantable users or roles for current user or role | 8.0.19 |
APPLICABLE_ROLES |
Applicable roles for current user | 8.0.19 |
CHARACTER_SETS |
Available character sets | |
CHECK_CONSTRAINTS |
Table and column CHECK constraints | 8.0.16 |
COLLATION_CHARACTER_SET_APPLICABILITY |
Character set applicable to each collation | |
COLLATIONS |
Collations for each character set | |
COLUMN_PRIVILEGES |
Privileges defined on columns | |
COLUMN_STATISTICS |
Histogram statistics for column values | |
COLUMNS |
Columns in each table | |
COLUMNS_EXTENSIONS |
Column attributes for primary and secondary storage engines | 8.0.21 |
ENABLED_ROLES |
Roles enabled within current session | 8.0.19 |
ENGINES |
Storage engine properties | |
EVENTS |
Event Manager events | |
FILES |
Files that store tablespace data | |
KEY_COLUMN_USAGE |
Which key columns have constraints | |
KEYWORDS |
MySQL keywords | |
ndb_transid_mysql_connection_map |
NDB transaction information | |
OPTIMIZER_TRACE |
Information produced by optimizer trace activity | |
PARAMETERS |
Stored routine parameters and stored function return values | |
PARTITIONS |
Table partition information | |
PLUGINS |
Plugin information | |
PROCESSLIST |
Information about currently executing threads | |
PROFILING |
Statement profiling information | |
REFERENTIAL_CONSTRAINTS |
Foreign key information | |
RESOURCE_GROUPS |
Resource group information | |
ROLE_COLUMN_GRANTS |
Column privileges for roles available to or granted by currently enabled roles | 8.0.19 |
ROLE_ROUTINE_GRANTS |
Routine privileges for roles available to or granted by currently enabled roles | 8.0.19 |
ROLE_TABLE_GRANTS |
Table privileges for roles available to or granted by currently enabled roles | 8.0.19 |
ROUTINES |
Stored routine information | |
SCHEMA_PRIVILEGES |
Privileges defined on schemas | |
SCHEMATA |
Schema information | |
SCHEMATA_EXTENSIONS |
Schema options | 8.0.22 |
ST_GEOMETRY_COLUMNS |
Columns in each table that store spatial data | |
ST_SPATIAL_REFERENCE_SYSTEMS |
Available spatial reference systems | |
ST_UNITS_OF_MEASURE |
Acceptable units for ST_Distance() | 8.0.14 |
STATISTICS |
Table index statistics | |
TABLE_CONSTRAINTS |
Which tables have constraints | |
TABLE_CONSTRAINTS_EXTENSIONS |
Table constraint attributes for primary and secondary storage engines | 8.0.21 |
TABLE_PRIVILEGES |
Privileges defined on tables | |
TABLES |
Table information | |
TABLES_EXTENSIONS |
Table attributes for primary and secondary storage engines | 8.0.21 |
TABLESPACES |
Tablespace information | |
TABLESPACES_EXTENSIONS |
Tablespace attributes for primary storage engines | 8.0.21 |
TRIGGERS |
Trigger information | |
USER_ATTRIBUTES |
User comments and attributes | 8.0.21 |
USER_PRIVILEGES |
Privileges defined globally per user | |
VIEW_ROUTINE_USAGE |
Stored functions used in views | 8.0.13 |
VIEW_TABLE_USAGE |
Tables and views used in views | 8.0.13 |
VIEWS |
View information |