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 Normalizing Database Tables.
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.