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-04-09 (revision: 65654)

---

Table of Contents

Preface and Legal Notices

1 INFORMATION_SCHEMA Tables

2 The INFORMATION_SCHEMA SCHEMATA Table

3 The INFORMATION_SCHEMA TABLES Table

4 The INFORMATION_SCHEMA COLUMNS Table

5 The INFORMATION_SCHEMA STATISTICS Table

6 The INFORMATION_SCHEMA USER_PRIVILEGES Table

7 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table

8 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table

9 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

10 The INFORMATION_SCHEMA CHARACTER_SETS Table

11 The INFORMATION_SCHEMA COLLATIONS Table

12 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table

13 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table

14 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table

15 The INFORMATION_SCHEMA ROUTINES Table

16 The INFORMATION_SCHEMA VIEWS Table

17 The INFORMATION_SCHEMA TRIGGERS Table

18 The INFORMATION_SCHEMA PLUGINS Table

19 The INFORMATION_SCHEMA ENGINES Table

20 The INFORMATION_SCHEMA PARTITIONS Table

21 The INFORMATION_SCHEMA EVENTS Table

22 The INFORMATION_SCHEMA FILES Table

23 The INFORMATION_SCHEMA PROCESSLIST Table

24 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table

25 Extensions to SHOW Statements

26 MySQL 8.0 FAQ: INFORMATION_SCHEMA