15.00 - Attributes Not Copied To The Target Table - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Attributes Not Copied To The Target Table

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” on page 657).