tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementSHOW DATABASES

SHOW DATABASES

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:10:35

Description

Supported engines: Presto and SparkSQL
Purpose: List all databases defined in the metadata. DATABASES or SCHEMAS has the same effect.

Statement

SHOW {DATABASES | SCHEMAS} [IN catalog_name] [LIKE 'regular_expression']

Parameter

[IN catalog_name]: Data source name.
[LIKE 'regular_expression']: Regular expression for filtering matching databases.

Example

SHOW DATABASES;
SHOW DATABASES LIKE '.*analytics';
SHOW DATABASES IN catalog1 LIKE '.*analytics';



Previous Topic: CREATE DATABASENext Topic: DESCRIBE DATABASE

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback