source_table - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples
Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
column_name
A column or list of columns from source_table_name to be copied to target table table_name.
If you create a target table from a normalized source table without specifying any new columns, Vantage creates the target table with the same NORMALIZE definition as the source table.
You cannot specify a column data type using the AS clause syntax.
column attributes
One or more new column attributes for the column set specified by column_name to be used for the new definition for table_name.
You cannot specify a foreign key constraint as a column attribute using the AS clause syntax.
table constraints
One or more new table constraints for the column set specified by column_name to be used for the new definition for table_name.
You cannot specify a foreign key constraint as a table constraint using the AS clause syntax.
database_name
user_name
The containing database or user for source_table_name if not the current database or user.
source_table_name
The name of the source table whose column- and table-level definitions (with some restrictions) and, optionally, data and statistics are to be copied to table_name.
You must specify source_table_name whether you use the AS source_table_name WITH DATA form or the AS SELECT … FROM source_table_name subquery form.
If the source table has derived period columns, the target table will also have those derived period columns.
You cannot use the CREATE TABLE … AS syntax, with a subquery that defines the source table, to create a table that is protected by row-level security constraints.