26.3.1 INFORMATION_SCHEMA General Table Reference

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

Table 26.2 INFORMATION_SCHEMA General Tables

Table NameDescriptionIntroduced
ADMINISTRABLE_ROLE_AUTHORIZATIONSGrantable users or roles for current user or role8.0.19
APPLICABLE_ROLESApplicable roles for current user8.0.19
CHARACTER_SETSAvailable character sets
CHECK_CONSTRAINTSTable and column CHECK constraints8.0.16
COLLATION_CHARACTER_SET_APPLICABILITYCharacter set applicable to each collation
COLLATIONSCollations for each character set
COLUMN_PRIVILEGESPrivileges defined on columns
COLUMN_STATISTICSHistogram statistics for column values
COLUMNSColumns in each table
COLUMNS_EXTENSIONSColumn attributes for primary and secondary storage engines8.0.21
ENABLED_ROLESRoles enabled within current session8.0.19
ENGINESStorage engine properties
EVENTSEvent Manager events
FILESFiles that store tablespace data
KEY_COLUMN_USAGEWhich key columns have constraints
KEYWORDSMySQL keywords
ndb_transid_mysql_connection_mapNDB transaction information
OPTIMIZER_TRACEInformation produced by optimizer trace activity
PARAMETERSStored routine parameters and stored function return values
PARTITIONSTable partition information
PLUGINSPlugin information
PROCESSLISTInformation about currently executing threads
PROFILINGStatement profiling information
REFERENTIAL_CONSTRAINTSForeign key information
RESOURCE_GROUPSResource group information
ROLE_COLUMN_GRANTSColumn privileges for roles available to or granted by currently enabled roles8.0.19
ROLE_ROUTINE_GRANTSRoutine privileges for roles available to or granted by currently enabled roles8.0.19
ROLE_TABLE_GRANTSTable privileges for roles available to or granted by currently enabled roles8.0.19
ROUTINESStored routine information
SCHEMA_PRIVILEGESPrivileges defined on schemas
SCHEMATASchema information
SCHEMATA_EXTENSIONSSchema options8.0.22
ST_GEOMETRY_COLUMNSColumns in each table that store spatial data
ST_SPATIAL_REFERENCE_SYSTEMSAvailable spatial reference systems
ST_UNITS_OF_MEASUREAcceptable units for ST_Distance()8.0.14
STATISTICSTable index statistics
TABLE_CONSTRAINTSWhich tables have constraints
TABLE_CONSTRAINTS_EXTENSIONSTable constraint attributes for primary and secondary storage engines8.0.21
TABLE_PRIVILEGESPrivileges defined on tables
TABLESTable information
TABLES_EXTENSIONSTable attributes for primary and secondary storage engines8.0.21
TABLESPACESTablespace information
TABLESPACES_EXTENSIONSTablespace attributes for primary storage engines8.0.21
TRIGGERSTrigger information
USER_ATTRIBUTESUser comments and attributes8.0.21
USER_PRIVILEGESPrivileges defined globally per user
VIEW_ROUTINE_USAGEStored functions used in views8.0.13
VIEW_TABLE_USAGETables and views used in views8.0.13
VIEWSView information