Primary key
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)
Read Also:
- Primary language
noun See native language
- Primary-letter
noun, Printing. 1. a lowercase character having neither a descender nor an ascender, as a, c, e, i, m, n, o, r, s, u, v, w, x, z.
- Primary lysosome
primary lysosome n. A cytoplasmic body that is produced at the Golgi complex where hydrolytic enzymes are incorporated.
- Primary management domain
messaging (PRMD) The component of an X.400 electronic mail address that gives the organisation name, usually abbreviated to p= in written addresses. See also ADMD. (2003-05-15)
- Primary-memory
noun, Computers. 1. main memory. noun, Computers. 1. program-addressable storage that is directly controlled by and generally contained in the CPU: except for cache storage, the fastest type of storage available to any computer system. noun 1. the central memory-storage facility in a computer