The SCHEMATA view contains details about databases (a schema is essentially a database).
| Column | Description |
|---|---|
CATALOG_NAME |
The name of the catalog to which the schema belongs. This value is always def. |
SCHEMA_NAME |
The name of the schema (database). |
DEFAULT_CHARACTER_SET_NAME |
The default character set for the schema. |
DEFAULT_COLLATION_NAME |
The default collation for the schema. |
SQL_PATH |
Always NULL. |
DEFAULT_ENCRYPTION |
The default encryption for the schema. |
Schema names are also available by using the SHOW DATABASES statement. А database appears in the output only if you have a privilege on that database or the global SHOW DATABASES privilege.
For more information, see the MySQL documentation: The INFORMATION_SCHEMA SCHEMATA Table.