SHOW VIEWS
NOTE!
For improved performance, execute this command in the
mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.
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. |
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