Primary Key



/ˈpraɪˌmɛri ki/


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.


Data Modeling

Related Terms

Product Information Encyclopedia

©2020 by Industrial Data Associates, Inc.

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