Purpose
information_schema.SCHEMATA displays the metadata information of the database.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| CATALOG_NAME | varchar(3) | NO | The name of the catalog to which the database belongs. The value of this field is fixed to def. |
| SCHEMA_NAME | varchar(128) | NO | The name of the database. |
| DEFAULT_CHARACTER_SET_NAME | varchar(7) | NO | The default character set. |
| DEFAULT_COLLATION_NAME | varchar(18) | NO | The default collation. |
| SQL_PATH | null | NO | NULL |