16.10 - PRIMARY KEY 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 PRIMARY KEY must also be NOT NULL.

Teradata Database instantiates a PRIMARY KEY as a unique primary or secondary index.

Only one PRIMARY KEY can be defined for a table.

For more details, see:

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