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


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
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