Overview
Displays database meta information.
Columns
Field |
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 comparison rule |
| SQL_PATH | null | NO | NULL |
| DEFAULT_ENCRYPTION | varchar(2) | NO | Whether to encrypt by default |
Sample query
Query the meta information 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