16.20 - Example: Attempting to Add and Drop Constraints in the Same Statement - 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

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.