ALTER PROJECTION RENAME

Initiates a rename operation on the specified projection.

Syntax

ALTER PROJECTION [schema.]projection‑name  RENAME TO new‑projection‑name 

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
projection‑name

The projection to change. See Projection Naming for projection name conventions.

new‑projection‑name

The new projection name.

Privileges

The following privileges are required:

Examples

This example shows how to rename a projection.

=> CREATE TABLE tbl (x integer, y integer);
CREATE TABLE
=> CREATE PROJECTION tbl_p AS SELECT x from tbl;
CREATE PROJECTION
=> ALTER PROJECTION tbl_p RENAME to new_tbl_p;
ALTER PROJECTION