Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 36.3Mb
PDF (A4) - 36.4Mb
PDF (RPM) - 35.5Mb
HTML Download (TGZ) - 9.3Mb
HTML Download (Zip) - 9.4Mb
HTML Download (RPM) - 8.1Mb
Man Pages (TGZ) - 235.5Kb
Man Pages (Zip) - 347.1Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  INFORMATION_SCHEMA General Table Reference

24.3.1 INFORMATION_SCHEMA General Table Reference

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

Table 24.2 INFORMATION_SCHEMA General Tables

Table Name Description
CHARACTER_SETS Available character sets
COLLATION_CHARACTER_SET_APPLICABILITY Character set applicable to each collation
COLLATIONS Collations for each character set
COLUMN_PRIVILEGES Privileges defined on columns
COLUMNS Columns in each table
ENGINES Storage engine properties
EVENTS Event Manager events
FILES Files that store tablespace data
GLOBAL_STATUS Global status variables
GLOBAL_VARIABLES Global system variables
KEY_COLUMN_USAGE Which key columns have constraints
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
ROUTINES Stored routine information
SCHEMA_PRIVILEGES Privileges defined on schemas
SCHEMATA Schema information
SESSION_STATUS Status variables for current session
SESSION_VARIABLES System variables for current session
STATISTICS Table index statistics
TABLE_CONSTRAINTS Which tables have constraints
TABLE_PRIVILEGES Privileges defined on tables
TABLES Table information
TABLESPACES Tablespace information
TRIGGERS Trigger information
USER_PRIVILEGES Privileges defined globally per user
VIEWS View information