> ## Documentation Index
> Fetch the complete documentation index at: https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW VIEWS

> Use the `SHOW VIEW` command to list existing views in a particular schema.

## Syntax

```sql theme={null}
SHOW VIEWS [ FROM schema_name ] [ LIKE_expression ];
```

## Parameters

| Parameter or clause | Description                                                                                                                                                                  |
| :------------------ | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *schema\_name*      | The schema from which existing views will be listed. If not given, views from the default schema, "public", will be listed.                                                  |
| LIKE\_expression    | Filters the output based on names by applying pattern matching. See details in [LIKE pattern matching expressions](/sql/functions/string#like-pattern-matching-expressions). |

## Example

Say we create the table `t3` in the `public` schema and a view `v3`.

```sql theme={null}
CREATE TABLE IF NOT EXISTS t3 (
    v1 int,
    v2 int,
    v3 int)
WITH (appendonly = 'true');

CREATE VIEW v3 AS SELECT sum(v2) AS sum_v2 FROM t3;
```

Then we can use `SHOW VIEWS` to show the existing views.

```sql theme={null}
SHOW VIEWS FROM public;
```

```bash theme={null}
v3
```

## Related topics

<CardGroup>
  <Card title="CREATE VIEW" icon="circle-plus" iconType="solid" href="/sql/commands/sql-create-view" />

  <Card title="SHOW CREATE VIEW" icon="eye" iconType="solid" href="/sql/commands/sql-show-create-view" />
</CardGroup>