Altering typed views
The ALTER VIEW statement modifies an existing view by altering a reference type column to add a scope. Any other changes you intend to make to a view require that you drop and then re-create the view.
About this task
When altering the view, the scope must be added to an existing reference type column that does not already have a scope defined. Further, the column must not be inherited from a superview.
The data type of the column name in the ALTER VIEW statement must be REF (type of the typed table name or typed view name).