Primary Key

n.

Pronunciation

/ˈpraɪˌmɛri ki/

Acronym

Definition

The unique identifying records in a relational database table.

Primary Keys are present in all relational database tables. They may exist in one column as a single identifying record or as a combination of multiple columns. The primary key may also be generated by the database itself. In product databases where there may be cost, description, and history tables for all products, a unique product number would serve as the primary key for an individual product across multiple tables.

Category

Data Modeling

Related Terms

Product Information Encyclopedia