15.00 - Usage Rules for Normalized Tables - 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)

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 … AS requests.

  • 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 the requestor.
  • 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.