16.20 - Dropping Columns from a Normalized Table - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
The following rules and restrictions apply to dropping columns from a normalized table.
  • You can drop any column from a normalized table, including ignore columns.
  • Dropping a normalized Period column also drops the NORMALIZE clause from the table definition.
  • Teradata Database renormalizes a normalized table if you drop a column that is not specified in the ignore column list from the table or when a column is added to the ignore column list.
  • You can use an ALTER TABLE request to alter the normalize_ignore_columns column list by specifying the DROP NORMALIZE option. This include the complete list - normalize clause and the ignore columns.
  • You cannot add and drop normalization from a table within the same ALTER TABLE request.

For information about adding columns to a normalized table, see Adding Columns to a Normalized Table.