NORMALIZE - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.