Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 48.1Mb
PDF (A4) - 48.1Mb
PDF (RPM) - 43.5Mb
HTML Download (TGZ) - 11.0Mb
HTML Download (Zip) - 11.1Mb
HTML Download (RPM) - 9.5Mb
Man Pages (TGZ) - 238.3Kb
Man Pages (Zip) - 342.8Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
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 ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
25.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
25.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
25.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
25.6 The INFORMATION_SCHEMA COLLATIONS Table
25.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
25.8 The INFORMATION_SCHEMA COLUMNS Table
25.9 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
25.10 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
25.11 The INFORMATION_SCHEMA ENABLED_ROLES Table
25.12 The INFORMATION_SCHEMA ENGINES Table
25.13 The INFORMATION_SCHEMA EVENTS Table
25.14 The INFORMATION_SCHEMA FILES Table
25.15 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
25.16 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
25.17 The INFORMATION_SCHEMA KEYWORDS Table
25.18 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
25.19 The INFORMATION_SCHEMA PARAMETERS Table
25.20 The INFORMATION_SCHEMA PARTITIONS Table
25.21 The INFORMATION_SCHEMA PLUGINS Table
25.22 The INFORMATION_SCHEMA PROCESSLIST Table
25.23 The INFORMATION_SCHEMA PROFILING Table
25.24 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
25.25 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
25.26 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
25.27 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
25.28 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
25.29 The INFORMATION_SCHEMA ROUTINES Table
25.30 The INFORMATION_SCHEMA SCHEMATA Table
25.31 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
25.32 The INFORMATION_SCHEMA STATISTICS Table
25.33 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
25.34 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
25.35 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
25.36 The INFORMATION_SCHEMA TABLES Table
25.37 The INFORMATION_SCHEMA TABLESPACES Table
25.38 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
25.39 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
25.40 The INFORMATION_SCHEMA TRIGGERS Table
25.41 The INFORMATION_SCHEMA USER_PRIVILEGES Table
25.42 The INFORMATION_SCHEMA VIEWS Table
25.43 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
25.44 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
25.45 INFORMATION_SCHEMA InnoDB Tables
25.45.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
25.45.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
25.45.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
25.45.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table
25.45.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
25.45.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
25.45.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
25.45.8 The INFORMATION_SCHEMA INNODB_COLUMNS Table
25.45.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table
25.45.10 The INFORMATION_SCHEMA INNODB_FIELDS Table
25.45.11 The INFORMATION_SCHEMA INNODB_FOREIGN Table
25.45.12 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table
25.45.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
25.45.14 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
25.45.15 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
25.45.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
25.45.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
25.45.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
25.45.19 The INFORMATION_SCHEMA INNODB_INDEXES Table
25.45.20 The INFORMATION_SCHEMA INNODB_LOCKS Table
25.45.21 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
25.45.22 The INFORMATION_SCHEMA INNODB_METRICS Table
25.45.23 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
25.45.24 The INFORMATION_SCHEMA INNODB_TABLES Table
25.45.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table
25.45.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table
25.45.27 The INFORMATION_SCHEMA INNODB_TABLESTATS View
25.45.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
25.45.29 The INFORMATION_SCHEMA INNODB_TRX Table
25.45.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table
25.46 INFORMATION_SCHEMA Thread Pool Tables
25.46.1 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
25.46.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
25.46.3 The INFORMATION_SCHEMA TP_THREAD_STATE Table
25.47 INFORMATION_SCHEMA Connection-Control Tables
25.47.1 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
25.48 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.