Contact MySQL  | 
Login  |  Register
The world's most popular open source database
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL Information Schema
  • Preface and Legal Notices
  • INFORMATION_SCHEMA Tables
  • The INFORMATION_SCHEMA SCHEMATA Table
  • The INFORMATION_SCHEMA TABLES Table
  • The INFORMATION_SCHEMA COLUMNS Table
  • The INFORMATION_SCHEMA STATISTICS Table
  • The INFORMATION_SCHEMA USER_PRIVILEGES Table
  • The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
  • The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
  • The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
  • The INFORMATION_SCHEMA CHARACTER_SETS Table
  • The INFORMATION_SCHEMA COLLATIONS Table
  • The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
  • The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
  • The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
  • The INFORMATION_SCHEMA ROUTINES Table
  • The INFORMATION_SCHEMA VIEWS Table
  • The INFORMATION_SCHEMA TRIGGERS Table
  • The INFORMATION_SCHEMA PLUGINS Table
  • The INFORMATION_SCHEMA ENGINES Table
  • The INFORMATION_SCHEMA PARTITIONS Table
  • The INFORMATION_SCHEMA EVENTS Table
  • The INFORMATION_SCHEMA FILES Table
  • The INFORMATION_SCHEMA PROCESSLIST Table
  • The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
  • Extensions to SHOW Statements
  • MySQL 8.0 FAQ: INFORMATION_SCHEMA
Related Documentation
MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
Download this Excerpt
PDF (US Ltr) - 240.7Kb
PDF (A4) - 242.9Kb
HTML Download (TGZ) - 47.1Kb
HTML Download (Zip) - 81.2Kb


version 8.0
5.7
5.6
5.5

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: 2019-12-13 (revision: 64537)


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

HOME   NEXT
Related Documentation
MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
Download this Excerpt
PDF (US Ltr) - 240.7Kb
PDF (A4) - 242.9Kb
HTML Download (TGZ) - 47.1Kb
HTML Download (Zip) - 81.2Kb
Contact MySQL Sales
USA/Canada: +1-866-221-0634   (More Countries »)
  © 2019, Oracle Corporation and/or its affiliates

  • Products
  • Oracle MySQL Cloud Service
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)
  • Services
  • Training
  • Certification
  • Consulting
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides
  • About MySQL
  • Contact Us
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  © 2019, Oracle Corporation and/or its affiliates
Legal Policies | Your Privacy Rights | Terms of Use | Trademark Policy | Contributor Agreement |