16.20 - PRIMARY KEY - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

A column set that ensures that no two rows in the table can be duplicates. Only one primary key can be specified per table. Internally, the system uses a unique primary or secondary index to enforce this constraint.

You cannot specify a PRIMARY KEY constraint for a QITS column. See QITS_column_name.