Changes the definition of a view.
ALTER VIEW <name> RENAME TO <newname>
ALTER VIEW
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.
Some variants of ALTER TABLE
can be used with views as well; for example, to rename a view, it is also possible to use ALTER TABLE RENAME
. To change the schema or owner of a view, you currently must use ALTER TABLE
.
Rename the view myview
to newview
:
ALTER VIEW myview RENAME TO newview;
Change the owner of tablespace myfs
:
ALTER FILESPACE myfs OWNER TO dba;
ALTER VIEW
is a Greenplum Database extension of the SQL standard.
CREATE VIEW, DROP VIEW in the Greenplum Database Utility Guide
Parent topic: SQL Command Reference