PRIMARY KEY - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

No two rows in the table can have the same value for the defined column set. The system uses a unique primary or secondary index to enforce this constraint.

Only one primary key can be specified per table. To specify candidate primary keys for referential integrity relationships with other tables, use the UNIQUE definition clause.

You cannot specify a PRIMARY KEY constraint for a QITS column (see QITS_column_name).

The system implicitly creates a unique index on any column set specified as PRIMARY KEY if it is not also defined to be the primary index for the table.