Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
PDF (RPM) - 39.8Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 244.2Kb
Man Pages (Zip) - 349.3Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  INFORMATION_SCHEMA Tables

Chapter 26 INFORMATION_SCHEMA Tables

Table of Contents

26.1 Introduction
26.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
26.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
26.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
26.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
26.6 The INFORMATION_SCHEMA COLLATIONS Table
26.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
26.8 The INFORMATION_SCHEMA COLUMNS Table
26.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table
26.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
26.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
26.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
26.13 The INFORMATION_SCHEMA ENGINES Table
26.14 The INFORMATION_SCHEMA EVENTS Table
26.15 The INFORMATION_SCHEMA FILES Table
26.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
26.17 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
26.18 The INFORMATION_SCHEMA KEYWORDS Table
26.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
26.20 The INFORMATION_SCHEMA PARAMETERS Table
26.21 The INFORMATION_SCHEMA PARTITIONS Table
26.22 The INFORMATION_SCHEMA PLUGINS Table
26.23 The INFORMATION_SCHEMA PROCESSLIST Table
26.24 The INFORMATION_SCHEMA PROFILING Table
26.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
26.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
26.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
26.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
26.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
26.30 The INFORMATION_SCHEMA ROUTINES Table
26.31 The INFORMATION_SCHEMA SCHEMATA Table
26.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
26.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
26.34 The INFORMATION_SCHEMA STATISTICS Table
26.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
26.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
26.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
26.38 The INFORMATION_SCHEMA TABLES Table
26.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
26.40 The INFORMATION_SCHEMA TABLESPACES Table
26.41 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
26.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
26.43 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
26.44 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
26.45 The INFORMATION_SCHEMA TRIGGERS Table
26.46 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
26.47 The INFORMATION_SCHEMA USER_PRIVILEGES Table
26.48 The INFORMATION_SCHEMA VIEWS Table
26.49 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
26.50 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
26.51 INFORMATION_SCHEMA InnoDB Tables
26.51.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
26.51.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
26.51.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
26.51.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table
26.51.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
26.51.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
26.51.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
26.51.8 The INFORMATION_SCHEMA INNODB_COLUMNS Table
26.51.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table
26.51.10 The INFORMATION_SCHEMA INNODB_FIELDS Table
26.51.11 The INFORMATION_SCHEMA INNODB_FOREIGN Table
26.51.12 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table
26.51.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
26.51.14 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
26.51.15 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
26.51.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
26.51.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
26.51.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
26.51.19 The INFORMATION_SCHEMA INNODB_INDEXES Table
26.51.20 The INFORMATION_SCHEMA INNODB_LOCKS Table
26.51.21 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
26.51.22 The INFORMATION_SCHEMA INNODB_METRICS Table
26.51.23 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
26.51.24 The INFORMATION_SCHEMA INNODB_TABLES Table
26.51.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table
26.51.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table
26.51.27 The INFORMATION_SCHEMA INNODB_TABLESTATS View
26.51.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
26.51.29 The INFORMATION_SCHEMA INNODB_TRX Table
26.51.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table
26.52 INFORMATION_SCHEMA Thread Pool Tables
26.52.1 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
26.52.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
26.52.3 The INFORMATION_SCHEMA TP_THREAD_STATE Table
26.53 INFORMATION_SCHEMA Connection-Control Tables
26.53.1 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
26.54 INFORMATION_SCHEMA MySQL Enterprise Firewall Tables
26.54.1 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table
26.54.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
26.55 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.