15.10 - PRIMARY KEY - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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” earlier in this table).

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.