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

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

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.