24.3 INFORMATION_SCHEMA General Tables

MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6

24.3 INFORMATION_SCHEMA General Tables

24.3.1 INFORMATION_SCHEMA General Table Reference
24.3.2 The INFORMATION_SCHEMA CHARACTER_SETS Table
24.3.3 The INFORMATION_SCHEMA COLLATIONS Table
24.3.4 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
24.3.5 The INFORMATION_SCHEMA COLUMNS Table
24.3.6 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
24.3.7 The INFORMATION_SCHEMA ENGINES Table
24.3.8 The INFORMATION_SCHEMA EVENTS Table
24.3.9 The INFORMATION_SCHEMA FILES Table
24.3.10 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
24.3.11 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
24.3.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
24.3.13 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
24.3.14 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
24.3.15 The INFORMATION_SCHEMA PARAMETERS Table
24.3.16 The INFORMATION_SCHEMA PARTITIONS Table
24.3.17 The INFORMATION_SCHEMA PLUGINS Table
24.3.18 The INFORMATION_SCHEMA PROCESSLIST Table
24.3.19 The INFORMATION_SCHEMA PROFILING Table
24.3.20 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
24.3.21 The INFORMATION_SCHEMA ROUTINES Table
24.3.22 The INFORMATION_SCHEMA SCHEMATA Table
24.3.23 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
24.3.24 The INFORMATION_SCHEMA STATISTICS Table
24.3.25 The INFORMATION_SCHEMA TABLES Table
24.3.26 The INFORMATION_SCHEMA TABLESPACES Table
24.3.27 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
24.3.28 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
24.3.29 The INFORMATION_SCHEMA TRIGGERS Table
24.3.30 The INFORMATION_SCHEMA USER_PRIVILEGES Table
24.3.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.