PRIMARY KEY Constraint - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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 Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144
  • “Keys” in Teradata Vantage™ SQL Fundamentals, B035-1141
  • “Constraint Specifications” in Teradata Vantage™ - Database Design, B035-1094.