INFORMATION_SCHEMA General Table Reference 4777 Table Name Description Introduced 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