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

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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.