Page History

...

As with ALTER TABLE, you can use this statement to add your own metadata to a view.

Alter View As Select

ALTER VIEW view_name AS select_statement

Alter View As Select changes the definition of a view, which must exist. The syntax is similar to that for CREATE VIEW and the effect is the same as for CREATE OR REPLACE VIEW.

Note: The view must already exist, and if the view has partitions, it could not be replaced by Alter View As Select.

Create/Drop Function

Create Function

...