(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
automatically generated byinfo2html