> ## 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.

# CREATE DERIVED VIEW Statements

> To create new derived views, use CREATE DERIVED VIEW statements.

## CREATE DERIVED VIEW Syntax

The CREATE DERIVED VIEW statement specifies the view name and the contents of the SQL query, as shown in the following example:

```sql theme={null}
CREATE DERIVED VIEW [<view_name>] AS <sql_query_contents>
```

The following example statement creates a derived view called MyViewName, with the query `SELECT * FROM Customers LIMIT 20;`

```sql theme={null}
CREATE DERIVED VIEW [MyViewName] AS SELECT * FROM Customers LIMIT 20;
```