16.20 - Example: Dropping a NORMALIZE Constraint From a Table - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

This example uses a nontemporal version of the project table from Example: Adding a NORMALIZE Constraint to a Table except that this table definition specifies a NORMALIZE ALL BUT constraint with the dept_id column specified in the normalize_ignore column list and the NORMALIZE constraint is defined on the duration column.

     CREATE TABLE project  (
       emp_id	         INTEGER,
       project_name	   VARCHAR(20),
       dept_id	        INTEGER,
       duration	       PERIOD(DATE),
       NORMALIZE ALL BUT(dept_id) ON duration);

The following ALTER TABLE request modifies the project table to remove the NORMALIZE constraint on the duration column.

     ALTER TABLE project
     DROP NORMALIZE;