> ## 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 MATERIALIZED VIEWS

> Use the `SHOW MATERIALZED VIEWS` command to show existing materialized views.

## Syntax

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

## Parameters

| Parameter        | Description                                                                                                                                                                  |
| :--------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *schema\_name*   | The schema in which the materialized views will be listed. If not given, materialized 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

```sql theme={null}
SHOW MATERIALIZED VIEWS FROM schema_1;
```