MySQL 8.3 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.15, “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.