ContextQMD
Back to Materialize

SHOW VIEWS

doc/user/content/sql/show-views.md

123784 B
Original Source

SHOW VIEWS returns a list of views in Materialize.

Syntax

mzsql
SHOW VIEWS [FROM <schema_name>];
Syntax elementDescription
FROM <schema_name>If specified, only show views from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.

Details

Output format for SHOW VIEWS

SHOW VIEWS's output is a table, with this structure:

nofmt
 name
-------
 ...
FieldMeaning
nameThe name of the view.

Examples

mzsql
SHOW VIEWS;
nofmt
  name
---------
 my_view