SHOW VIEWS

SHOW VIEWS returns a list of views in your Materialize instances.

Syntax

Field	Use
schema_name	The schema to show sources 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 VIEW`

SHOW FULL VIEW’s output is a table, with this structure:

 VIEWS | TYPE | QUERYABLE | MATERIALIZED
-------+------+-----------+--------------
 ...   | ...  | ...       | ...

Field	Meaning
VIEWS	The name of the view
TYPE	Whether the view was created by the user or the system
QUERYABLE	Can the view process `SELECT` statements? You can always `SELECT FROM...` materialized views, but non-materialized views have a specific set of requirements.
MATERIALIZED	Does the view have an in-memory index? For more details, see `CREATE INDEX`

Examples

Default behavior

SHOW VIEWS;

         VIEWS
-------------------------
 my_nonmaterialized_view
 my_materialized_view

Only show materialized views

SHOW MATERIALIZED VIEWS;

        VIEWS
----------------------
 my_materialized_view

Show details about views

SHOW FULL VIEWS

          VIEWS          | TYPE | QUERYABLE | MATERIALIZED
-------------------------+------+-----------+--------------
 my_nonmaterialized_view | USER | t         | f
 my_materialized_view    | USER | t         | t

In this case my_nonmaterialized_view would only be queryable if it depended on my_materialized_view, e.g.

CREATE VIEW my_nonmaterialized_view AS
    SELECT col2, col3 FROM my_materialized_view;