create-table-column-name-list.md
Valid only when creating a table from a query (AS
query
), defines column names that map to the query output. If you omit this list, Vertica uses the query output column names.
This clause and the ENCODED BY
clause are mutually exclusive. Column name lists are invalid for external tables.
The names in column-name-list
and queried columns must be the same in number.