Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.4Mb
PDF (RPM) - 39.9Mb
HTML Download (TGZ) - 10.6Mb
HTML Download (Zip) - 10.6Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 241.3Kb
Man Pages (Zip) - 346.4Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
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 COLUMNS_EXTENSIONS Table
25.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
25.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
25.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
25.13 The INFORMATION_SCHEMA ENGINES Table
25.14 The INFORMATION_SCHEMA EVENTS Table
25.15 The INFORMATION_SCHEMA FILES Table
25.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
25.17 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
25.18 The INFORMATION_SCHEMA KEYWORDS Table
25.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
25.20 The INFORMATION_SCHEMA PARAMETERS Table
25.21 The INFORMATION_SCHEMA PARTITIONS Table
25.22 The INFORMATION_SCHEMA PLUGINS Table
25.23 The INFORMATION_SCHEMA PROCESSLIST Table
25.24 The INFORMATION_SCHEMA PROFILING Table
25.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
25.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
25.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
25.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
25.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
25.30 The INFORMATION_SCHEMA ROUTINES Table
25.31 The INFORMATION_SCHEMA SCHEMATA Table
25.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
25.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
25.34 The INFORMATION_SCHEMA STATISTICS Table
25.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
25.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
25.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
25.38 The INFORMATION_SCHEMA TABLES Table
25.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
25.40 The INFORMATION_SCHEMA TABLESPACES Table
25.41 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
25.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
25.43 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
25.44 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
25.45 The INFORMATION_SCHEMA TRIGGERS Table
25.46 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
25.47 The INFORMATION_SCHEMA USER_PRIVILEGES Table
25.48 The INFORMATION_SCHEMA VIEWS Table
25.49 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
25.50 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
25.51 INFORMATION_SCHEMA InnoDB Tables
25.51.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
25.51.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
25.51.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
25.51.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table
25.51.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
25.51.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
25.51.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
25.51.8 The INFORMATION_SCHEMA INNODB_COLUMNS Table
25.51.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table
25.51.10 The INFORMATION_SCHEMA INNODB_FIELDS Table
25.51.11 The INFORMATION_SCHEMA INNODB_FOREIGN Table
25.51.12 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table
25.51.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
25.51.14 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
25.51.15 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
25.51.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
25.51.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
25.51.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
25.51.19 The INFORMATION_SCHEMA INNODB_INDEXES Table
25.51.20 The INFORMATION_SCHEMA INNODB_LOCKS Table
25.51.21 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
25.51.22 The INFORMATION_SCHEMA INNODB_METRICS Table
25.51.23 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
25.51.24 The INFORMATION_SCHEMA INNODB_TABLES Table
25.51.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table
25.51.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table
25.51.27 The INFORMATION_SCHEMA INNODB_TABLESTATS View
25.51.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
25.51.29 The INFORMATION_SCHEMA INNODB_TRX Table
25.51.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table
25.52 INFORMATION_SCHEMA Thread Pool Tables
25.52.1 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
25.52.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
25.52.3 The INFORMATION_SCHEMA TP_THREAD_STATE Table
25.53 INFORMATION_SCHEMA Connection-Control Tables
25.53.1 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
25.54 INFORMATION_SCHEMA MySQL Enterprise Firewall Tables
25.54.1 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table
25.54.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
25.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.