{ “title”: “SHOW-DATABASES”, “language”: “en” }

SHOW-DATABASES

Name

SHOW DATABASES

Description

This statement is used to display the currently visible db

grammar:

SHOW DATABASES [FROM catalog] [filter expr];

illustrate:

  1. SHOW DATABASES will get all database names from current catalog.
  2. SHOW DATABASES FROM catalog will all database names from the catalog named ‘catalog’.
  3. SHOW DATABASES filter_expr will get filtered database names from current catalog.
  4. SHOW DATABASES FROM catalog filter_expr is not support yet.

Example

  1. Display all the database names from current catalog.

    SHOW DATABASES;

+--------------------+ | Database           | +--------------------+ | test               | | information_schema | +--------------------+

2. Display all database names from the catalog named 'hms_catalog'.

```sql
SHOW DATABASES from hms_catalog;

+---------------+
| Database      |
+---------------+
| default       |
| tpch          |
+---------------+

  1. Display the filtered database names from current catalog with the expr ‘like’.
    SHOW DATABASES like 'infor%';

+--------------------+ | Database           | +--------------------+ | information_schema | +--------------------+

### Keywords

 SHOW, DATABASES

### Best Practice