ALTER VIEW

Modifies a view.

Synopsis

ALTER VIEW view-name [(column-commalist)] AS query

Arguments

view-name	The view being modified, which has the same naming rules as a table name.
column-commalist	The column names that compose the view.
query	The result set (from a query) that serves as a the basis for the view.

Description

The ALTER VIEW command allows you to modify a view. A view is based on the result set from a query consisting of a single SELECT statement. Note that UNION operations cannot be used with views.

By specifying a named list of columns in the view, you can avoid including these in the query. For instance:

ALTER VIEW MyView ( ViewCol1, ViewCol2, ViewCol3 ) AS
     SELECT TableCol1, TableCol2, TableCol3 FROM MyTable

is the same as:

ALTER VIEW MyView AS SELECT TableCol1 AS ViewCol1,
     TableCol2 AS ViewCol2,
     TableCol3 AS ViewCol3
     FROM MyTable