SHOW DATABASES

Function Description

SHOW DATABASES Lists the databases on MatrixOne. SHOW SCHEMAS is synonymous with SHOW DATABASES.

If the LIKE clause exists, it indicates which database names need to be matched. The WHERE clause can use common conditions to select rows.

MatrixOne displays the database in the data directory.

Database information is also available from the INFORMATION_SCHEMA SCHEMATA table.

Function Syntax

> SHOW {DATABASES | SCHEMAS}
    [LIKE 'pattern' | WHERE expr]

Example

create database demo_1;

mysql> show databases;
+-------------------------+
| Database |
+-------------------------+
| mo_task |
| information_schema |
| mysql |
| system_metrics |
| system |
| demo_1 |
| mo_catalog |
+-------------------------+
7 rows in set (0.00 sec)