MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
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 |
---|---|
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 |