Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 338.6Kb
PDF (A4) - 343.1Kb
HTML Download (TGZ) - 60.4Kb
HTML Download (Zip) - 122.5Kb


MySQL Information Schema

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-09-17 (revision: 67385)


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