This topic describes how to view databases by using the SHOW DATABASES statement.
Procedure
Log in to a user tenant of the cluster.
Use the
SHOW DATABASESstatement to view the database information of the tenant.Here is an example:
obclient> SHOW DATABASES;The query result is as follows:
+--------------------+ | Database | +--------------------+ | oceanbase | | information_schema | | mysql | | test | +--------------------+ 3 rows in setinformation_schemaallows you to access the database metadata. This is a built-in database of the tenant.oceanbasestores the system tables of OceanBase AI Database.mysqlstores database users, privilege settings, and keywords.testis a custom database created by the user.