Replaces a view definition with a modified version. You must include the entire new view definition in the ALTER VIEW statement.
ALTER VIEW ... [ owner.]view-name [( column-name [, ...] )] ... AS select-without-order-by ... [ WITH CHECK OPTION ]
The ALTER VIEW statement is identical in syntax to the CREATE VIEW statement except for the first word. The ALTER VIEW statement replaces the entire contents of the CREATE VIEW statement with the contents of the ALTER VIEW statement. Existing permissions on the view are maintained, and do not have to be reassigned. If a DROP VIEW followed by CREATE VIEW is used, instead of ALTER VIEW, permissions on the view would have to be reassigned.
If
SELECT * is used in a view definition and a table referenced
by the SELECT * is altered, then you must run ALTER VIEW
<viewname> RECOMPILE to ensure that the view definition is correct
and to prevent unexpected results when querying the view.
Automatic commit.
Must be owner of the view or have DBA authority.
