Skip to main content

ALTER MATERIALIZED VIEW

Synopsis​

ALTER MATERIALIZED VIEW [ IF EXISTS ] name RENAME TO new_name
ALTER MATERIALIZED VIEW name SET PROPERTIES property_name = expression [, ...]

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.

SET PROPERTIES​

The ALTER MATERALIZED VIEW SET PROPERTIES statement followed by some number of property_name and expression pairs applies the specified properties and values to a materialized view. Ommitting an already-set property from this statement leaves that property unchanged in the materialized view.

A property in a SET PROPERTIES statement can be set to DEFAULT, which reverts its value back to the default in that materialized view.

Support for ALTER MATERIALIZED VIEW SET PROPERTIES varies between connectors. Refer to the connector documentation for more details.

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;

Set view properties (x = y) in materialized view people:

ALTER MATERIALIZED VIEW people SET PROPERTIES x = 'y';

Set multiple view properties (foo = 123 and foo bar = 456) in materialized view people:

ALTER MATERALIZED VIEW people SET PROPERTIES foo = 123, "foo bar" = 456;

Set view property x to its default value in materialized view people:

ALTER MATERALIZED VIEW people SET PROPERTIES x = DEFAULT;

See also​

  • CREATE MATERIALIZED VIEW
  • REFRESH MATERIALIZED VIEW
  • DROP MATERIALIZED VIEW