17.00 - UNIQUE - 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)

Any two rows in the table cannot have the same value or combination of values in the indexed columns.

You cannot specify UNIQUE for a secondary index:

  • if you also specify ALL.
  • for a secondary index defined on a join index.
  • if you also specify an ORDER BY clause.
  • for a column that has a LOB UDT or XML data type.