An optional clause for selecting a subset of the column definitions or all of the column definitions from source_table_name.
The subquery form is only valid if you also specify a WITH DATA clause.
You cannot use the subquery form of CREATE TABLE AS to copy the NORMALIZE definition from a source table to a target table.
You cannot specify the NORMALIZE option or the EXPAND ON clause in the SELECT subquery where you specify NO PRIMARY INDEX for the target table.
- SELECT column_name FROM source_table_name
- Select a subset of the column definitions from source_table_name.
- SELECT * FROM source_table_name
- Select all of the column definitions from source_table_name.