Specifying View Column Names
- <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
SELECTstatement, 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
UNIONclauses. You must write an embedded application to create this type of view.