Amazon Athena
User Guide  | API Reference

SHOW DATABASES

Lists all databases defined in the metastore. You can use DATABASES or SCHEMAS. They mean the same thing.

Synopsis#

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

Parameters#

[LIKE 'regular_expression']
Filters the list of databases to those that match the regular_expression you specify. Wildcards can only be *, which indicates any character, or |, which indicates a choice between characters.

Examples#

SHOW SCHEMAS;

SHOW DATABASES LIKE '*analytics';