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

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
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.