16.20 - Attributes Not Copied To The Target Table - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
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).