17.10 - Example: Attempting to Add a Constraint with a Duplicate Name - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

The following request is not valid because the constraint named dup_constr_name already exists in table_1. You cannot add it to the table.

    ALTER TABLE table_1
      ADD CONSTRAINT dup_constr_name
      FOREIGN KEY (column_3) REFERENCES table_2;

The system returns the following message:

Constraint with the same name 'dup_constr_name' already exists in table.