4.1 INFORMATION_SCHEMA General Table Reference

The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions.

Table 4.1 INFORMATION_SCHEMA General Tables

Table Name	Description	Introduced	Deprecated
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		8.0.22
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