SHOW VIEWS
SHOW VIEWS returns a list of views in your Materialize instances.
Syntax
| Field | Use |
|---|---|
| schema_name | The schema to show views from. Defaults to public in the current database. For available schemas, see SHOW SCHEMAS. |
| MATERIALIZED | Only return materialized views, i.e. those with indexes. Without specifying this option, this command returns all views, including non-materialized views. |
| FULL | Return details about your views. |
Details
Output format for SHOW FULL VIEWS
SHOW FULL VIEWS’s output is a table, with this structure:
name | type | materialized | volatility
-------+------+--------------+-----------
... | ... | ... | ...
| Field | Meaning |
|---|---|
| name | The name of the view |
| type | Whether the view was created by the user or the system |
| materialized | Does the view have an in-memory index? For more details, see CREATE INDEX |
| volatility | Whether the view is volatile. Either volatile, nonvolatile, or unknown. |
Changed in v0.5.0:
The Name, Type, and Materialized columns are renamed to lowercase, i.e.,
name, type, and materialized, respectively.
New in v0.7.2:
The volatile column.
Examples
Default behavior
SHOW VIEWS;
name
-------------------------
my_nonmaterialized_view
my_materialized_view
Only show materialized views
SHOW MATERIALIZED VIEWS;
name
----------------------
my_materialized_view
Show details about views
SHOW FULL VIEWS
name | type | materialized
-------------------------+------+--------------
my_nonmaterialized_view | user | f
my_materialized_view | user | t