Chapter 26 INFORMATION

26.3 INFORMATION_SCHEMA General Tables

26.3.1 INFORMATION_SCHEMA General Table Reference
26.3.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
26.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
26.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
26.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
26.3.6 The INFORMATION_SCHEMA COLLATIONS Table
26.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
26.3.8 The INFORMATION_SCHEMA COLUMNS Table
26.3.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table
26.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
26.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
26.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
26.3.13 The INFORMATION_SCHEMA ENGINES Table
26.3.14 The INFORMATION_SCHEMA EVENTS Table
26.3.15 The INFORMATION_SCHEMA FILES Table
26.3.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
26.3.17 The INFORMATION_SCHEMA KEYWORDS Table
26.3.18 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
26.3.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
26.3.20 The INFORMATION_SCHEMA PARAMETERS Table
26.3.21 The INFORMATION_SCHEMA PARTITIONS Table
26.3.22 The INFORMATION_SCHEMA PLUGINS Table
26.3.23 The INFORMATION_SCHEMA PROCESSLIST Table
26.3.24 The INFORMATION_SCHEMA PROFILING Table
26.3.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
26.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
26.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
26.3.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
26.3.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
26.3.30 The INFORMATION_SCHEMA ROUTINES Table
26.3.31 The INFORMATION_SCHEMA SCHEMATA Table
26.3.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
26.3.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
26.3.34 The INFORMATION_SCHEMA STATISTICS Table
26.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
26.3.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
26.3.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
26.3.38 The INFORMATION_SCHEMA TABLES Table
26.3.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
26.3.40 The INFORMATION_SCHEMA TABLESPACES Table
26.3.41 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
26.3.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
26.3.43 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
26.3.44 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
26.3.45 The INFORMATION_SCHEMA TRIGGERS Table
26.3.46 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
26.3.47 The INFORMATION_SCHEMA USER_PRIVILEGES Table
26.3.48 The INFORMATION_SCHEMA VIEWS Table
26.3.49 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
26.3.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.