show-databases.md 769 B
title: "SHOW DATABASES"
description: "SHOW DATABASES returns a list of all databases in Materialize."
menu:
main:
parent: commands
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 | If specified, only show databases that match the condition(s). |