Note
This view is introduced since OceanBase Database V1.4.
Purpose
This view displays database metadata.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CATALOG_NAME | varchar(3) | NO | The catalog. The value of this column 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 | The value is NULL. |
| DEFAULT_ENCRYPTION | varchar(2) | NO | Indicates whether encryption is enabled by default. |
Sample query
Query the metadata of all databases in the cluster.
obclient [oceanbase]> SELECT * FROM information_schema.SCHEMATA;
The query result is as follows:
obclient [oceanbase]> SELECT * FROM information_schema.SCHEMATA;
+--------------+--------------------+----------------------------+------------------------+----------+--------------------+
| CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH | DEFAULT_ENCRYPTION |
+--------------+--------------------+----------------------------+------------------------+----------+--------------------+
| def | oceanbase | utf8mb4 | utf8mb4_general_ci | NULL | NO |
| def | information_schema | utf8mb4 | utf8mb4_general_ci | NULL | NO |
| def | mysql | utf8mb4 | utf8mb4_general_ci | NULL | NO |
| def | SYS | utf8mb4 | utf8mb4_general_ci | NULL | NO |
| def | LBACSYS | utf8mb4 | utf8mb4_general_ci | NULL | NO |
| def | ORAAUDITOR | utf8mb4 | utf8mb4_general_ci | NULL | NO |
| def | test | utf8mb4 | utf8mb4_general_ci | NULL | NO |
| def | sys_external_tbs | utf8mb4 | utf8mb4_general_ci | NULL | NO |
+--------------+--------------------+----------------------------+------------------------+----------+--------------------+
8 rows in set