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

# ALTER VIEW

<a id="sql-alter-view" />

Alters the configuration of a [view](/content/sql/ddl/create-view#sql-create-view).

The following facet of a *view* can be altered:

* [Schema](/content/sql/ddl/alter-view#sql-alter-view-move)

<a id="sql-alter-view-move" />

## Move View

A *view* can be moved from one schema to another.

```sql title="Move View Syntax" theme={null}
ALTER VIEW [<schema name>.]<view name>
< MOVE TO | SET SCHEMA > <new schema name>
```

All dependent [views](/content/sql/ddl/create-view#sql-create-view),
[materialized views](/content/sql/ddl/create-materialized-view#sql-create-materialized-view),
[streams](/content/sql/ddl/create-stream#sql-create-stream), and
[SQL procedures](/content/sql/procedure#sql-procedures) will be dropped.

For example, to move the `sales_2017` *view* from the `example_olap`
*schema* to the `example_archive` *schema*:

```sql Move View Example theme={null}
ALTER VIEW example_olap.sales_2017
MOVE TO example_archive;
```