# ALTER MATERIALIZED VIEW#

## Synopsis#

ALTER MATERIALIZED VIEW [ IF EXISTS ] name RENAME TO new_name


## Description#

Change the name of an existing materialized view.

The optional IF EXISTS clause causes the error to be suppressed if the materialized view does not exist. The error is not suppressed if the materialized view does not exist, but a table or view with the given name exists.

## Examples#

Rename materialized view people to users in the current schema:

ALTER MATERIALIZED VIEW people RENAME TO users;


Rename materialized view people to users, if materialized view people exists in the current catalog and schema:

ALTER MATERIALIZED VIEW IF EXISTS people RENAME TO users;