Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 97.6Kb
HTML Download (Zip) - 110.0Kb


MySQL Information Schema  /  INFORMATION_SCHEMA General Tables

Chapter 4 INFORMATION_SCHEMA General Tables

Table of Contents

4.1 INFORMATION_SCHEMA General Table Reference
4.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
4.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
4.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
4.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
4.6 The INFORMATION_SCHEMA COLLATIONS Table
4.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
4.8 The INFORMATION_SCHEMA COLUMNS Table
4.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table
4.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
4.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
4.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
4.13 The INFORMATION_SCHEMA ENGINES Table
4.14 The INFORMATION_SCHEMA EVENTS Table
4.15 The INFORMATION_SCHEMA FILES Table
4.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
4.17 The INFORMATION_SCHEMA KEYWORDS Table
4.18 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
4.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
4.20 The INFORMATION_SCHEMA PARAMETERS Table
4.21 The INFORMATION_SCHEMA PARTITIONS Table
4.22 The INFORMATION_SCHEMA PLUGINS Table
4.23 The INFORMATION_SCHEMA PROCESSLIST Table
4.24 The INFORMATION_SCHEMA PROFILING Table
4.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
4.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
4.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
4.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
4.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
4.30 The INFORMATION_SCHEMA ROUTINES Table
4.31 The INFORMATION_SCHEMA SCHEMATA Table
4.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
4.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
4.34 The INFORMATION_SCHEMA STATISTICS Table
4.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
4.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
4.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
4.38 The INFORMATION_SCHEMA TABLES Table
4.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
4.40 The INFORMATION_SCHEMA TABLESPACES Table
4.41 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
4.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
4.43 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
4.44 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
4.45 The INFORMATION_SCHEMA TRIGGERS Table
4.46 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
4.47 The INFORMATION_SCHEMA USER_PRIVILEGES Table
4.48 The INFORMATION_SCHEMA VIEWS Table
4.49 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
4.50 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table

The following sections describe what may be denoted as the general set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.