<div id="docs-body">
 <div class="chapter">
  <div class="titlepage">
   <div>
    <div>
     <h1 class="title">
      <a name="information-schema">
      </a>
      Chapter 28 INFORMATION_SCHEMA Tables
     </h1>
    </div>
   </div>
  </div>
  <div class="toc">
   <p>
    <b>
     Table of Contents
    </b>
   </p>
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="information-schema-introduction.html">
       28.1 Introduction
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="information-schema-table-reference.html">
       28.2 INFORMATION_SCHEMA Table Reference
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="general-information-schema-tables.html">
       28.3 INFORMATION_SCHEMA General Tables
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="information-schema-general-table-reference.html">
         28.3.1 INFORMATION_SCHEMA General Table Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-administrable-role-authorizations-table.html">
         28.3.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-applicable-roles-table.html">
         28.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-character-sets-table.html">
         28.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-check-constraints-table.html">
         28.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-collations-table.html">
         28.3.6 The INFORMATION_SCHEMA COLLATIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-collation-character-set-applicability-table.html">
         28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-columns-table.html">
         28.3.8 The INFORMATION_SCHEMA COLUMNS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-columns-extensions-table.html">
         28.3.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-column-privileges-table.html">
         28.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-column-statistics-table.html">
         28.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-enabled-roles-table.html">
         28.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-engines-table.html">
         28.3.13 The INFORMATION_SCHEMA ENGINES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-events-table.html">
         28.3.14 The INFORMATION_SCHEMA EVENTS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-files-table.html">
         28.3.15 The INFORMATION_SCHEMA FILES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-key-column-usage-table.html">
         28.3.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-keywords-table.html">
         28.3.17 The INFORMATION_SCHEMA KEYWORDS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-ndb-transid-mysql-connection-map-table.html">
         28.3.18 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-optimizer-trace-table.html">
         28.3.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-parameters-table.html">
         28.3.20 The INFORMATION_SCHEMA PARAMETERS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-partitions-table.html">
         28.3.21 The INFORMATION_SCHEMA PARTITIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-plugins-table.html">
         28.3.22 The INFORMATION_SCHEMA PLUGINS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-processlist-table.html">
         28.3.23 The INFORMATION_SCHEMA PROCESSLIST Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-profiling-table.html">
         28.3.24 The INFORMATION_SCHEMA PROFILING Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-referential-constraints-table.html">
         28.3.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-resource-groups-table.html">
         28.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-role-column-grants-table.html">
         28.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-role-routine-grants-table.html">
         28.3.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-role-table-grants-table.html">
         28.3.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-routines-table.html">
         28.3.30 The INFORMATION_SCHEMA ROUTINES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-schemata-table.html">
         28.3.31 The INFORMATION_SCHEMA SCHEMATA Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-schemata-extensions-table.html">
         28.3.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-schema-privileges-table.html">
         28.3.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-statistics-table.html">
         28.3.34 The INFORMATION_SCHEMA STATISTICS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-st-geometry-columns-table.html">
         28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-st-spatial-reference-systems-table.html">
         28.3.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-st-units-of-measure-table.html">
         28.3.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-tables-table.html">
         28.3.38 The INFORMATION_SCHEMA TABLES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-tables-extensions-table.html">
         28.3.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-tablespaces-extensions-table.html">
         28.3.40 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-table-constraints-table.html">
         28.3.41 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-table-constraints-extensions-table.html">
         28.3.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-table-privileges-table.html">
         28.3.43 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-triggers-table.html">
         28.3.44 The INFORMATION_SCHEMA TRIGGERS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-user-attributes-table.html">
         28.3.45 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-user-privileges-table.html">
         28.3.46 The INFORMATION_SCHEMA USER_PRIVILEGES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-views-table.html">
         28.3.47 The INFORMATION_SCHEMA VIEWS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-view-routine-usage-table.html">
         28.3.48 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-view-table-usage-table.html">
         28.3.49 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-tables.html">
       28.4 INFORMATION_SCHEMA InnoDB Tables
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-table-reference.html">
         28.4.1 INFORMATION_SCHEMA InnoDB Table Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-buffer-page-table.html">
         28.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-buffer-page-lru-table.html">
         28.4.3 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-buffer-pool-stats-table.html">
         28.4.4 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-cached-indexes-table.html">
         28.4.5 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-cmp-table.html">
         28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-cmpmem-table.html">
         28.4.7 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-cmp-per-index-table.html">
         28.4.8 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-columns-table.html">
         28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-datafiles-table.html">
         28.4.10 The INFORMATION_SCHEMA INNODB_DATAFILES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-fields-table.html">
         28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-foreign-table.html">
         28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-foreign-cols-table.html">
         28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-ft-being-deleted-table.html">
         28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-ft-config-table.html">
         28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-ft-default-stopword-table.html">
         28.4.16 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-ft-deleted-table.html">
         28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-ft-index-cache-table.html">
         28.4.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-ft-index-table-table.html">
         28.4.19 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-indexes-table.html">
         28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-metrics-table.html">
         28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-session-temp-tablespaces-table.html">
         28.4.22 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-tables-table.html">
         28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-tablespaces-table.html">
         28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-tablespaces-brief-table.html">
         28.4.25 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-tablestats-table.html">
         28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-temp-table-info-table.html">
         28.4.27 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-trx-table.html">
         28.4.28 The INFORMATION_SCHEMA INNODB_TRX Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-innodb-virtual-table.html">
         28.4.29 The INFORMATION_SCHEMA INNODB_VIRTUAL Table
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="thread-pool-information-schema-tables.html">
       28.5 INFORMATION_SCHEMA Thread Pool Tables
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="information-schema-thread-pool-table-reference.html">
         28.5.1 INFORMATION_SCHEMA Thread Pool Table Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-tp-thread-group-state-table.html">
         28.5.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-tp-thread-group-stats-table.html">
         28.5.3 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-tp-thread-state-table.html">
         28.5.4 The INFORMATION_SCHEMA TP_THREAD_STATE Table
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="connection-control-information-schema-tables.html">
       28.6 INFORMATION_SCHEMA Connection-Control Tables
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="information-schema-connection-control-table-reference.html">
         28.6.1 INFORMATION_SCHEMA Connection-Control Table Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-connection-control-failed-login-attempts-table.html">
         28.6.2 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="firewall-information-schema-tables.html">
       28.7 INFORMATION_SCHEMA MySQL Enterprise Firewall Tables
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="information-schema-firewall-table-reference.html">
         28.7.1 INFORMATION_SCHEMA Firewall Table Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-mysql-firewall-users-table.html">
         28.7.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="information-schema-mysql-firewall-whitelist-table.html">
         28.7.3 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="extended-show.html">
       28.8 Extensions to SHOW Statements
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045081058336">
  </a>
  <a class="indexterm" name="idm46045081056880">
  </a>
  <a class="indexterm" name="idm46045081055808">
  </a>
  <a class="indexterm" name="idm46045081054736">
  </a>
  <a class="indexterm" name="idm46045081053664">
  </a>
  <p>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   provides access to database
   <span class="firstterm">
    metadata
   </span>
   , information about
    the MySQL server such as the name of a database or table, the data
    type of a column, or access privileges. Other terms that are
    sometimes used for this information are
   <span class="firstterm">
    data dictionary
   </span>
   and
   <span class="firstterm">
    system catalog
   </span>
   .
  </p>
 </div>
 <br/>
</div>
