ALTER VIEW

The ALTER VIEW statement changes the schema of an existing view in the catalog.

Examples

Rename a view:

Query

ALTER VIEW view1 RENAME TO view2;

Tip

ALTER VIEW changes the schema of an existing view.