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

SHOW VIEWS FROM schema_name
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
Back to top ↑