SHOW DATABASES - Materialize

SHOW DATABASES returns a list of all databases in Materialize.

Syntax

sql

SHOW DATABASES
[LIKE <pattern> | WHERE <condition(s)>]
;

Syntax element	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).

SHOW DATABASES's output is a table with one column, name.

mzsql

CREATE DATABASE my_db;

mzsql

SHOW DATABASES;

nofmt

materialize
my_db