Specifying View Column Names

Go Up to Creating Views (Data Definition Guide)

• <view_col> names one or more columns for the view. Column names are optional unless the view includes columns based on expressions. When specified, view column names correspond in order and number to the columns listed in the SELECT statement, so you must specify view column names for every column selected, or do not specify names at all.
• Column names must be unique among all column names in the view. If column names are not specified, the view takes the column names from the underlying table by default.
• If the view definition includes an expression, <view_col> names are required. A <view_col> definition can contain one or more columns based on an expression.

Note:
isql does not support view definitions containing UNION clauses. You must write an embedded application to create this type of view.

Advance To:

• Using the SELECT Statement