Materialize Documentation
Join the Community github/materialize

SHOW VIEWS

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