| 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
|
|
|---|
