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