(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) INFORMATION_SCHEMA

 
 21.1 `INFORMATION_SCHEMA' Tables
 ================================
 
 *Explanation of following sections*
 
 In the following sections, we take the tables and columns that are in
 `INFORMATION_SCHEMA'.  For each column, there are three pieces of
 information:
 
    * "Standard Name" indicates the standard SQL name for the column.
 
    * "`SHOW' name" indicates what the equivalent field name is in the
      closest `SHOW' statement, if any.
 
    * "Remarks" provides additional information where applicable.  We
      have marked "omit" those columns for which MySQL has no present
      use. We have omitted these columns, that is, they appear in the
      standard but not in MySQL. So their presence here is a matter of
      record only.
 
 
 To avoid using any name that's reserved in the standard or in DB2 or in
 SQL Server or in Oracle we changed the names of columns marked "MySQL
 extension." (For example, we changed `COLLATION' to `TABLE_COLLATION'
 in the `TABLES' table.) See the list of reserved words near the end of
 this article: `http://www.dbazine.com/gulutzan5.shtml'.
 
 The definition for character columns (for example,
 `TABLES.TABLE_NAME'), is generally `VARCHAR(N) CHARACTER SET utf8'
 where N is at least 64.
 
 Each section indicates what `SHOW' statement is equivalent to a
 `SELECT' that retrieves information from `INFORMATION_SCHEMA', or else
 that there is no such equivalent statement.
 
 * At present, there are some missing columns and some columns out
 of order.  We are working on that and will update the documentation as
 changes are made.

 
* SCHEMATA Table              The `INFORMATION_SCHEMA SCHEMATA' Table
* TABLES Table                The `INFORMATION_SCHEMA TABLES' Table
* COLUMNS Table               The `INFORMATION_SCHEMA COLUMNS' Table
* STATISTICS Table            The `INFORMATION_SCHEMA STATISTICS' Table
* USER_PRIVILEGES Table       The `INFORMATION_SCHEMA USER_PRIVILEGES' Table
* SCHEMA_PRIVILEGES Table     The `INFORMATION_SCHEMA SCHEMA_PRIVILEGES' Table
* TABLE_PRIVILEGES Table      The `INFORMATION_SCHEMA TABLE_PRIVILEGES' Table
* COLUMN_PRIVILEGES Table     The `INFORMATION_SCHEMA COLUMN_PRIVILEGES' Table
* CHARACTER_SETS Table        The `INFORMATION_SCHEMA CHARACTER_SETS' Table
* COLLATIONS Table            The `INFORMATION_SCHEMA COLLATIONS' Table
* COLLATION_CHARACTER_SET_APPLICABILITY Table  The `INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY' Table
* TABLE_CONSTRAINTS Table     The `INFORMATION_SCHEMA TABLE_CONSTRAINTS' Table
* KEY_COLUMN_USAGE Table      The `INFORMATION_SCHEMA KEY_COLUMN_USAGE' Table
* ROUTINES Table              The `INFORMATION_SCHEMA ROUTINES' Table
* VIEWS Table                 The `INFORMATION_SCHEMA VIEWS' Table
* Other INFORMATION_SCHEMA Tables  Other `INFORMATION_SCHEMA' Tables

Info Catalog

(mysql.info.gz) INFORMATION_SCHEMA

(mysql.info.gz) Extended SHOW

automatically generated byinfo2html

(mysql.info.gz) INFORMATION_SCHEMA Tables

Menu