> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ALTER DERIVED VIEW Statements

> Use the ALTER DERIVED VIEW statement to assign a new SQL query to a derived view.

## ALTER DERIVED VIEW Syntax

```bash theme={null}
ALTER DERIVED VIEW [<view_name>] AS <sql_query_contents>
```

The following query changes an existing derived view, MyViewName, to a new SQL query:

```bash theme={null}
ALTER DERIVED VIEW [MyViewName] AS SELECT * FROM Customers WHERE TimeModified > '3/1/2020';
```