Amazon Athena
User Guide

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

On this page: