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

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;