15.00 - Using Identity Columns - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Using Identity Columns

The most frequent use of identity columns is as surrogate keys. An identity column is an optional column attribute. When you associate an identity column attribute with a column, Teradata Database generates a table‑level unique number for the column for every inserted row.

Identity column values are returned as part of the response, if an AGKR (Auto Generated Key Retrieval) option flag in the request-level Options parcel is set, when an INSERT or INSERT … SELECT request is executed.