A column or set of columns defined as PRIMARY KEY must also be NOT NULL.
Teradata Database instantiates a PRIMARY KEY as a unique primary or secondary index.
Only one PRIMARY KEY can be defined for a table.
For more details, see:
- “CREATE TABLE” in SQL Data Definition Language.
- “Keys” in SQL Fundamentals.
- “Constraint Specifications” in Database Design.