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;