MySQL 9.5 Release Notes
A schema is a database, so the SCHEMATA table provides information about databases.
The SCHEMATA table has these columns:
CATALOG_NAMEThe name of the catalog to which the schema belongs. This value is always
def.SCHEMA_NAMEThe name of the schema.
DEFAULT_CHARACTER_SET_NAMEThe schema default character set.
DEFAULT_COLLATION_NAMEThe schema default collation.
SQL_PATHThis value is always
NULL.DEFAULT_ENCRYPTIONThe schema default encryption.
Schema names are also available from the SHOW DATABASES statement. See Section 15.7.7.16, “SHOW DATABASES Statement”. The following statements are equivalent:
SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild'] You see only those databases for which you have some kind of privilege, unless you have the global SHOW DATABASES privilege.
Caution
Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except databases that have been restricted at the database level by partial revokes.
Notes
The
SCHEMATA_EXTENSIONStable augments theSCHEMATAtable with information about schema options.