16.10 - UNIQUE Constraint - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

A column or set of columns defined as UNIQUE must also be NOT NULL.

Teradata Database instantiates UNIQUE as a unique primary or secondary index. One or more columns or sets of columns can be defined as UNIQUE for a table.

For more details, see:

  • “CREATE TABLE” in SQL Data Definition Language.
  • “Constraint Specifications” in Database Design.