Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 47.0Mb
PDF (A4) - 47.1Mb
PDF (RPM) - 42.4Mb
HTML Download (TGZ) - 10.8Mb
HTML Download (Zip) - 10.9Mb
HTML Download (RPM) - 9.4Mb
Man Pages (TGZ) - 226.8Kb
Man Pages (Zip) - 333.5Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  INFORMATION_SCHEMA Tables

Chapter 25 INFORMATION_SCHEMA Tables

Table of Contents     [+/-]

25.1 Introduction
25.2 The INFORMATION_SCHEMA CHARACTER_SETS Table
25.3 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
25.4 The INFORMATION_SCHEMA COLLATIONS Table
25.5 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
25.6 The INFORMATION_SCHEMA COLUMNS Table
25.7 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
25.8 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
25.9 The INFORMATION_SCHEMA ENGINES Table
25.10 The INFORMATION_SCHEMA EVENTS Table
25.11 The INFORMATION_SCHEMA FILES Table
25.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
25.13 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
25.14 The INFORMATION_SCHEMA KEYWORDS Table
25.15 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
25.16 The INFORMATION_SCHEMA PARAMETERS Table
25.17 The INFORMATION_SCHEMA PARTITIONS Table
25.18 The INFORMATION_SCHEMA PLUGINS Table
25.19 The INFORMATION_SCHEMA PROCESSLIST Table
25.20 The INFORMATION_SCHEMA PROFILING Table
25.21 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
25.22 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
25.23 The INFORMATION_SCHEMA ROUTINES Table
25.24 The INFORMATION_SCHEMA SCHEMATA Table
25.25 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
25.26 The INFORMATION_SCHEMA STATISTICS Table
25.27 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
25.28 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
25.29 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
25.30 The INFORMATION_SCHEMA TABLES Table
25.31 The INFORMATION_SCHEMA TABLESPACES Table
25.32 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
25.33 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
25.34 The INFORMATION_SCHEMA TRIGGERS Table
25.35 The INFORMATION_SCHEMA USER_PRIVILEGES Table
25.36 The INFORMATION_SCHEMA VIEWS Table
25.37 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
25.38 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
25.39 INFORMATION_SCHEMA InnoDB Tables     [+/-]
25.40 INFORMATION_SCHEMA Thread Pool Tables     [+/-]
25.41 INFORMATION_SCHEMA Connection-Control Tables     [+/-]
25.42 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.