Usage Rules for Normalized Tables
With the exception of the following list, the rules for creating a normalized table
using a CREATE TABLE request and creating a normalized table using a CREATE TABLE
… AS request are the same. For a complete list of those rules, see “Rules and Restrictions for the NORMALIZE Option” on page 571.
Following is a list of exceptions to the rules that are specific to CREATE TABLE …
You cannot specify the NORMALIZE option for the target table in a CREATE TABLE … AS
request. Otherwise, Teradata Database aborts the request and returns a message to
A target table created with a CREATE TABLE … AS request 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.