Chapter 4 INFORMATION_SCHEMA General Tables

Table of Contents

4.1 INFORMATION_SCHEMA General Table Reference

4.2 The INFORMATION_SCHEMA CHARACTER_SETS Table

4.3 The INFORMATION_SCHEMA COLLATIONS Table

4.4 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table

4.5 The INFORMATION_SCHEMA COLUMNS Table

4.6 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

4.7 The INFORMATION_SCHEMA ENGINES Table

4.8 The INFORMATION_SCHEMA EVENTS Table

4.9 The INFORMATION_SCHEMA FILES Table

4.10 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables

4.11 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables

4.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table

4.13 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table

4.14 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table

4.15 The INFORMATION_SCHEMA PARAMETERS Table

4.16 The INFORMATION_SCHEMA PARTITIONS Table

4.17 The INFORMATION_SCHEMA PLUGINS Table

4.18 The INFORMATION_SCHEMA PROCESSLIST Table

4.19 The INFORMATION_SCHEMA PROFILING Table

4.20 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table

4.21 The INFORMATION_SCHEMA ROUTINES Table

4.22 The INFORMATION_SCHEMA SCHEMATA Table

4.23 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table

4.24 The INFORMATION_SCHEMA STATISTICS Table

4.25 The INFORMATION_SCHEMA TABLES Table

4.26 The INFORMATION_SCHEMA TABLESPACES Table

4.27 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table

4.28 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table

4.29 The INFORMATION_SCHEMA TRIGGERS Table

4.30 The INFORMATION_SCHEMA USER_PRIVILEGES Table

4.31 The INFORMATION_SCHEMA VIEWS Table

The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.