Attributes Not Copied To The Target Table - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™
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).