SHOW DATABASES
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';
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback