Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


MySQL Information Schema  /  INFORMATION_SCHEMA General Tables  /  INFORMATION_SCHEMA General Table Reference

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