首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 6dd8e59864
Branches Tags
Materialize
/
doc
/
user
/
content
/
sql
/
show-schemas.md

show-schemas.md 921 B
History Raw

title: "SHOW SCHEMAS" description: "SHOW SCHEMAS returns a list of all schemas available in Materialize." menu: main:

parent: commands

SHOW SCHEMAS returns a list of all schemas available in Materialize.

Syntax

SHOW SCHEMAS [ FROM <database_name> ]

Details

Output format

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

Examples

SHOW DATABASES;

   name
-----------
materialize
my_db

SHOW SCHEMAS FROM my_db

  name
--------
 public

Related pages

Option Description
FROM If specified, only show schemas from the specified database. Defaults to the current database. For available databases, see SHOW DATABASES.