15.10 - Source Table - 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
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, Teradata Database 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.