Example: Adding a Named UNIQUE Constraint to a Table - Teradata Vantage - Analytics Database

Constraint name unique_1 must not be an existing constraint name in table_1.

ALTER TABLE table_1 ADD CONSTRAINT unique_1 UNIQUE (column_1, column_2);