17.10 - Attributes Not Copied To The Target Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
The following list describes attributes that are not copied to a target table from the source table or query expression using an AS clause with CREATE TABLE.
  • The following source table attributes are not copied to the target table because they affect multiple tables.
    • REFERENCES constraints
    • Triggers
  • When an existing source table (not a subquery) is specified in the AS clause and indexes are specified in the Index Definition clause, then source table indexes are not copied to the target table.
  • When a subquery is specified in the AS clause, indexes from tables specified in the subquery are not copied. Any indexes you want for the target table must be specified explicitly. If you do not specify an explicit primary index, the system chooses a default primary index.
  • When the source definition is taken from a query expression, the system does not carry the table kind over to the target table definition (see Target Table Kind Defaults).