(mysql.info.gz) SCHEMATA Table

Info Catalog

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) TABLES Table

 
 21.1.1 The `INFORMATION_SCHEMA SCHEMATA' Table
 ----------------------------------------------
 
 A schema is a database, so the `SCHEMATA' table provides information
 about databases.
 
 *Standard Name*               *`SHOW' name*          *Remarks*
 `CATALOG_NAME'                -                      `NULL'
 `SCHEMA_NAME'                                        Database
 `SCHEMA_OWNER'                                       omit
 `DEFAULT_CHARACTER_SET_CATALOG'                       omit
 `DEFAULT_CHARACTER_SET_SCHEMA'                       omit
 `DEFAULT_CHARACTER_SET_NAME'                         
 `SQL_PATH'                                           `NULL'
 
 Notes:
 
    * For `SQL_PATH', we might eventually support something in MySQL
      5.x. For now, it's always `NULL'.
 
 
 The following statements are equivalent:
 
      SELECT SCHEMA_NAME AS `Database`
        FROM INFORMATION_SCHEMA.SCHEMATA
        [WHERE SCHEMA_NAME LIKE 'wild']
 
      SHOW DATABASES
        [LIKE 'wild']
 

Info Catalog

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) TABLES Table