15.00 - Specific Rules For CREATE TABLE AS … WITH NO DATA That Does Not Use a Subquery To Define The Source Table Column And Index Set - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Specific Rules For CREATE TABLE AS … WITH NO DATA That Does Not Use a Subquery To Define The Source Table Column And Index Set

In addition to the set of general rules provided in “General Rules For CREATE TABLE AS … WITH NO DATA” on page 667, the following list of specific rules applies only to an AS … WITH NO DATA clause that does not specify a subquery.

  • Teradata Database copies all the available single-column statistics on source table columns as zeroed statistics.
  • Teradata Database copies all available multicolumn statistics except those multicolumn statistics that include the system-derived column PARTITION as multicolumn zeroed statistics.
  • Teradata Database 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.
  • Teradata Database 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.