primary key

Computing Dictionary

primary key definition

database
A unique identifier, often an integer, that labels a certain row in a table of a relational database.
When this value occurs in other tables as a reference to a particular row in the first table it is called a "foreign key".
Some RDBMSes can generate a new unique identifier each time a new row is inserted, others merely allow a column to be constrained to contain unique values.
A table may have multiple candidate keys, from which the primary key is chosen. The primary key should be an arbitrary value, such as an autoincrementing integer. This avoids dependence on uniqueness, permanence and format of existing columns with real-world meaning (e.g. a person's name) or other external identifier (e.g. social security number).
There should be enough possible primary key values to cater for the current and expected number of rows, bearing in mind that a wider column will generally be slower to process.
(2006-05-29)
The Free On-line Dictionary of Computing, © Denis Howe 2010 http://foldoc.org
Cite This Source
Explore Dictionary.com
Previous Definition: primary intention
Next Definition: primary language
Words Near: primary key
More from Thesaurus.com
Synonyms and Antonyms for primary key
More from Reference.com
Search for articles containing primary key
More from Dictionary.com Translator
Dictionary.com Word FAQs

Dictionary.com presents 366 FAQs, incorporating some of the frequently asked questions from the past with newer queries.

Copyright © 2014 Dictionary.com, LLC. All rights reserved.
  • Please Login or Sign Up to use the Recent Searches feature
FAVORITES
RECENT

;