15.10 - Subquery Clause - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.

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.