SHOW DATABASES
SHOW DATABASES returns a list of all databases in Materialize.
Syntax
SHOW DATABASES
[LIKE <pattern> | WHERE <condition(s)>]
| Option | Description |
|---|---|
| LIKE <pattern> | If specified, only show databases that match the pattern. |
| WHERE <condition(s)> | If specified, only show databases that match the condition(s). |
Details
Output format
SHOW DATABASES’s output is a table with one column, name.
Examples
CREATE DATABASE my_db;
SHOW DATABASES;
materialize
my_db