17.05 - NORMALIZE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

Increases individual date ranges in the column to provide an overall range.

You can only add one NORMALIZE option for a table.

You cannot normalize a volatile table.

To normalize a table defined with columns of the JSON or DATASET data type, you must explicitly specify those columns as members of the ALL BUT (normalize_ignore_column_name) column set.

ADD
Add the specified normalize_column to table_name as a constraint for normalization purposes.
ON normalize_column
Column to add as a constraint for normalization purposes.
ON OVERLAPS
When date ranges in the column overlap.
ON MEETS OR OVERLAPS
ON OVERLAPS OR MEETS
When date ranges in the column overlap or meet.
ALL BUT (normalize_ignore_column_name)
Add table columns to the list of columns that are not to be considered for normalization.
DROP
The NORMALIZE constraint is to be removed from the normalize_column.