SHOW VIEWS
SHOW VIEWS
returns a list of views in Materialize.
Syntax
Field | Use |
---|---|
schema_name | The schema to show views from. 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:
name
-------
...
Field | Meaning |
---|---|
name | The name of the view. |
Examples
SHOW VIEWS;
name
---------
my_view