# **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**

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

## **Example**

```text
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)
```