Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.4Mb
PDF (A4) - 39.5Mb
PDF (RPM) - 38.7Mb
HTML Download (TGZ) - 11.0Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.7Mb
Man Pages (TGZ) - 215.6Kb
Man Pages (Zip) - 325.0Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  INFORMATION_SCHEMA Tables

Chapter 24 INFORMATION_SCHEMA Tables

Table of Contents     [+/-]

24.1 Introduction
24.2 The INFORMATION_SCHEMA CHARACTER_SETS Table
24.3 The INFORMATION_SCHEMA COLLATIONS Table
24.4 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
24.5 The INFORMATION_SCHEMA COLUMNS Table
24.6 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
24.7 The INFORMATION_SCHEMA ENGINES Table
24.8 The INFORMATION_SCHEMA EVENTS Table
24.9 The INFORMATION_SCHEMA FILES Table
24.10 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
24.11 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
24.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
24.13 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
24.14 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
24.15 The INFORMATION_SCHEMA PARAMETERS Table
24.16 The INFORMATION_SCHEMA PARTITIONS Table
24.17 The INFORMATION_SCHEMA PLUGINS Table
24.18 The INFORMATION_SCHEMA PROCESSLIST Table
24.19 The INFORMATION_SCHEMA PROFILING Table
24.20 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
24.21 The INFORMATION_SCHEMA ROUTINES Table
24.22 The INFORMATION_SCHEMA SCHEMATA Table
24.23 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
24.24 The INFORMATION_SCHEMA STATISTICS Table
24.25 The INFORMATION_SCHEMA TABLES Table
24.26 The INFORMATION_SCHEMA TABLESPACES Table
24.27 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
24.28 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
24.29 The INFORMATION_SCHEMA TRIGGERS Table
24.30 The INFORMATION_SCHEMA USER_PRIVILEGES Table
24.31 The INFORMATION_SCHEMA VIEWS Table
24.32 INFORMATION_SCHEMA InnoDB Tables     [+/-]
24.33 INFORMATION_SCHEMA Thread Pool Tables     [+/-]
24.34 INFORMATION_SCHEMA Connection-Control Tables     [+/-]
24.35 Extensions to SHOW Statements

INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data dictionary and system catalog.