Abstract
This is the MySQL Information Schema extract from the MySQL 8.0 Reference Manual.
For legal information, see the Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2020-11-09 (revision: 67967)
Table of Contents
- Preface and Legal Notices
- 1 INFORMATION_SCHEMA Tables
- 2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
- 3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
- 4 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
- 6 The INFORMATION_SCHEMA COLLATIONS Table
- 7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 8 The INFORMATION_SCHEMA COLUMNS Table
- 9 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 10 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
- 11 The INFORMATION_SCHEMA ENABLED_ROLES Table
- 12 The INFORMATION_SCHEMA ENGINES Table
- 13 The INFORMATION_SCHEMA EVENTS Table
- 14 The INFORMATION_SCHEMA FILES Table
- 15 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 16 The INFORMATION_SCHEMA KEYWORDS Table
- 17 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
- 18 The INFORMATION_SCHEMA PARAMETERS Table
- 19 The INFORMATION_SCHEMA PARTITIONS Table
- 20 The INFORMATION_SCHEMA PLUGINS Table
- 21 The INFORMATION_SCHEMA PROCESSLIST Table
- 22 The INFORMATION_SCHEMA PROFILING Table
- 23 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 24 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
- 25 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
- 26 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
- 27 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
- 28 The INFORMATION_SCHEMA ROUTINES Table
- 29 The INFORMATION_SCHEMA SCHEMATA Table
- 30 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
- 31 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 32 The INFORMATION_SCHEMA STATISTICS Table
- 33 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
- 34 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
- 35 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
- 36 The INFORMATION_SCHEMA TABLES Table
- 37 The INFORMATION_SCHEMA TABLESPACES Table
- 38 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 39 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 40 The INFORMATION_SCHEMA TRIGGERS Table
- 41 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
- 42 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 43 The INFORMATION_SCHEMA VIEWS Table
- 44 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
- 45 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
- 46 Extensions to SHOW Statements
- 47 MySQL 8.0 FAQ: INFORMATION_SCHEMA