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