A schema is a database, so the
SCHEMATA table provides information
SCHEMATA table has these columns:
The name of the catalog to which the schema belongs. This value is always
The name of the schema.
The schema default character set.
The schema default collation.
This value is always
The schema default encryption. This column was added in MySQL 8.0.16.
Schema names are also available from the
DATABASES statement. See
Section 126.96.36.199, “SHOW DATABASES Statement”. The following statements are
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
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
DATABASES or by examining the
SCHEMATA table of
INFORMATION_SCHEMA, except databases that
have been restricted at the database level by partial revokes.
SCHEMATA_EXTENSIONStable augments the
SCHEMATAtable with information about schema options.