15.10 - Example: Dropping a NORMALIZE Constraint From a Table - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;