ALTER VIEW

Description

changes the definition of a view. The only currently available functionality is to rename the view. To execute this command you must be the owner of the view.

name

The (optionally schema-qualified) name of an existing filespace.

The new name of the view.

Notes

Some variants of ALTER TABLE can be used with views as well; for example, to rename a view, it is also possible to use . To change the schema or owner of a view, you currently must use ALTER TABLE.

Rename the view to newview:

Compatibility

ALTER VIEW is a Greenplum Database extension of the SQL standard.

, DROP VIEW in the Greenplum Database Utility Guide

Parent topic: