ALTER VIEW

The ALTER VIEW command modifies the metadata of a view. To use this command, you must own the view.

Syntax

ALTER VIEW view_name
    alter_option;

alter_option depends on the operation you want to perform on the view. For all supported clauses, see the sections below.

Clause

OWNER TO

ALTER VIEW view_name
    OWNER TO new_user;

Parameter or clause	Description
OWNER TO	This clause changes the owner of the view.
new_user	The new owner you want to assign to the view.

-- Change the owner of the view named "view1" to user "user1"
ALTER VIEW view1 OWNER TO user1;

SET SCHEMA

ALTER VIEW view_name
    SET SCHEMA schema_name;

Parameter or clause	Description
SET SCHEMA	This clause moves the view to a different schema.
schema_name	The name of the schema to which the view will be moved.

-- Move the view named "test_view" to the schema named "test_schema"
ALTER VIEW test_view SET SCHEMA test_schema;

RENAME TO

ALTER VIEW view_name
    RENAME TO new_name;

Parameter or clause	Description
RENAME TO	This clause changes the name of the view.
new_name	The new name of the view.

-- Change the name of the view named "view1" to "view2"
ALTER VIEW view1 RENAME TO view2;

SWAP WITH

ALTER VIEW name
SWAP WITH target_name;

Parameter	Description
name	The current name of the view to swap.
target_name	The target name of the view you want to swap with.

-- Swap the names of the user_profiles view and the guest_profiles view.
ALTER VIEW user_profiles
SWAP WITH guest_profiles;