Rules For CREATE TABLE AS … WITH NO DATA That Does Not Use a Subquery To Define The Source - 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™
In addition to the set of general rules provided in General Rules For CREATE TABLE AS … WITH NO DATA, the following list of specific rules applies only to an AS … WITH NO DATA clause that does not specify a subquery.
  • Vantage copies all the available single-column statistics on source table columns as zeroed statistics.
  • Vantage copies all available multicolumn statistics except those multicolumn statistics that include the system-derived column PARTITION as multicolumn zeroed statistics.
  • Vantage copies all available statistics from source table indexes to the target table as zeroed index statistics when you do not define any indexes for the target table.
  • Vantage copies all available statistics on the system-derived PARTITION column and any multicolumn statistics that include the system-derived PARTITION columns in their column set as single-column and multicolumn zeroed statistics, respectively, from source table column sets to the target table as zeroed index statistics when you do not define any indexes for the target table.