A column or column set as the PRIMARY KEY constraint for the table. Columns specified in a PRIMARY KEY constraint must all be defined as NOT NULL.
For nontemporal tables, the PRIMARY KEY constraint implicitly uses a USI.
For temporal tables, the PRIMARY KEY constraint implicitly uses a single-table join index or, in certain cases, a USI. For details, see Teradata Vantage™ - Temporal Table Support, B035-1182.
For an unnamed PRIMARY KEY table constraint, use this syntax:
CONSTRAINT PRIMARY KEY (column_name)
- CONSTRAINT constraint_name
- For a named PRIMARY KEY table constraint, use this syntax:
CONSTRAINT constraint_name PRIMARY KEY (column_name)