Reference Manual
CHAPTER 9. SQL Statements
To replace a view definition with a modified version. You must include the entire new view definition in the ALTER VIEW statement, and reassign permissions on the view
ALTER VIEW
... [ owner.]view-name [( column-name, ... )]
... AS select-without-order-by
... [ WITH CHECK OPTION ]
Must be owner of the view or have DBA authority.
Automatic commit.
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 and CREATE VIEW were carried out, permissions on the view would have to be reassigned.
SQL/92 Vendor extension
Sybase Not supported by Adaptive Server Enterprise.