Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 27.0Mb
PDF (A4) - 27.0Mb
PDF (RPM) - 25.4Mb
HTML Download (TGZ) - 6.3Mb
HTML Download (Zip) - 6.4Mb
HTML Download (RPM) - 5.4Mb
Man Pages (TGZ) - 159.2Kb
Man Pages (Zip) - 263.0Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

MySQL 5.5 Reference Manual  /  INFORMATION_SCHEMA Tables

Chapter 21 INFORMATION_SCHEMA Tables

Table of Contents     [+/-]

21.1 Introduction
21.2 The INFORMATION_SCHEMA CHARACTER_SETS Table
21.3 The INFORMATION_SCHEMA COLLATIONS Table
21.4 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
21.5 The INFORMATION_SCHEMA COLUMNS Table
21.6 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
21.7 The INFORMATION_SCHEMA ENGINES Table
21.8 The INFORMATION_SCHEMA EVENTS Table
21.9 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
21.10 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
21.11 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
21.12 The INFORMATION_SCHEMA PARAMETERS Table
21.13 The INFORMATION_SCHEMA PARTITIONS Table
21.14 The INFORMATION_SCHEMA PLUGINS Table
21.15 The INFORMATION_SCHEMA PROCESSLIST Table
21.16 The INFORMATION_SCHEMA PROFILING Table
21.17 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
21.18 The INFORMATION_SCHEMA ROUTINES Table
21.19 The INFORMATION_SCHEMA SCHEMATA Table
21.20 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
21.21 The INFORMATION_SCHEMA STATISTICS Table
21.22 The INFORMATION_SCHEMA TABLES Table
21.23 The INFORMATION_SCHEMA TABLESPACES Table
21.24 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
21.25 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
21.26 The INFORMATION_SCHEMA TRIGGERS Table
21.27 The INFORMATION_SCHEMA USER_PRIVILEGES Table
21.28 The INFORMATION_SCHEMA VIEWS Table
21.29 INFORMATION_SCHEMA InnoDB Tables     [+/-]
21.30 INFORMATION_SCHEMA NDB Cluster Tables     [+/-]
21.31 INFORMATION_SCHEMA Thread Pool Tables     [+/-]
21.32 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.