SHOW-DATABASES

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'.

   SHOW DATABASES from hms_catalog;

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

3. Display the filtered database names from current catalog with the expr 'like'.

   SHOW DATABASES like 'infor%';

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

Keywords

SHOW, DATABASES

Best Practice