Purpose
The information_schema.SCHEMATA view displays database metadata.
Note
This view is introduced since OceanBase Database V1.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CATALOG_NAME | varchar(3) | NO | The name of the catalog to which the database belongs. The value is always 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 |
| DEFAULT_ENCRYPTION | varchar(2) | NO | Indicates whether encryption is enabled by default. |