Primary Key

n.

Pronunciation

/ˈpraɪˌmɛri ki/

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

©2019 by Industrial Data Associates, Inc.

4041 N. Milwaukee, Suite 301, Chicago, IL 60641, US

Have an Edit?

Logo-2CRev-34px-TM.png