16.20 - Subquery Clause - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

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.