Primary Key - Teradata Vantage - Analytics Database

Database Introduction

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-21
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

A Primary Key (PK) defines one or more columns that uniquely identify a row in a table. Because it is used for identification, no column in a PK can be null. If you change or reuse a PK, historical information and relationships with others tables may be lost.

PK is a data modeling term and logical relational database concept. The columns identified as the PK during the data modeling process are often chosen for the UPI of a table. However, physical database design considerations often lead to a choice of columns other than those of the primary key for the PI of a table.