17.00 - Example: Attempting to Add and Drop Constraints in the Same Statement - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

The following request is not valid because you can add or drop only one constraint per ALTER TABLE request:

    ALTER TABLE table_1
      DROP CONSTRAINT check_1,
      ADD CONSTRAINT check_2 CHECK (column_2 > 0);

The system returns the following message:

     Only a check specification is allowed for the modification.