16.20 - Usage Rules for Normalized Tables - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

With the exception of the following list, the rules for creating a normalized table using a CREATE TABLE statement and creating a normalized table using a CREATE TABLE … AS statement are the same. For a complete list of those rules, see Rules and Restrictions for the NORMALIZE Option.

Following is a list of exceptions to the rules that are specific to CREATE TABLE … AS statements.
  • You cannot specify the NORMALIZE option for the target table in a CREATE TABLE … AS statement.
  • A target table created with a CREATE TABLE … AS statement has the same NORMALIZE definition as the source table if you do not declare any columns.
  • If you create the target table using a subquery, the table does not inherit the NORMALIZE specification of the source table.