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.*, which matches any character zero to unlimited times.
Examples
SHOW SCHEMAS;
SHOW DATABASES LIKE '.*analytics';