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:
- Ownership of the projection's anchor table
- USAGE and CREATE privileges on the projection's schema
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