Note
This view is available starting with V1.4.
Purpose
This view displays database metadata.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| CATALOG_NAME | varchar(3) | NO | Fixed value def |
| SCHEMA_NAME | varchar(128) | NO | Database name |
| DEFAULT_CHARACTER_SET_NAME | varchar(7) | NO | Default character set |
| DEFAULT_COLLATION_NAME | varchar(18) | NO | Default collation |
| SQL_PATH | null | NO | NULL |
| DEFAULT_ENCRYPTION | varchar(2) | NO | Default encryption status |
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