show-views.md 898 B
title: "SHOW VIEWS"
description: "SHOW VIEWS returns a list of views in Materialize."
menu:
main:
parent: commands
SHOW VIEWS returns a list of views in Materialize.
Syntax
SHOW VIEWS [FROM <schema_name>]
| Option | Description |
|---|---|
| FROM | If specified, only show views from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS. |
| Field | Meaning |
|---|---|
| name | The name of the view. |
Examples
SHOW VIEWS;
name
---------
my_view