17.10 - Usage Rules for Normalized Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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.