Word:

surrogate key

(database)surrogate key - A unique primary key generated by the RDBMS that is not derived from any data in the database and whose only significance is to act as the primary key.

A surrogate key is frequently a sequential number (e.g. a Sybase "identity column") but doesn't have to be. Having the key independent of all other columns insulates the database relationships from changes in data values or database design and guarantees uniqueness.

Some database designers use surrogate keys religiously regardless of the suitability of other candidate keys. However, if a good key already exists, the addition of a surrogate key will merely slow down access, particularly if it is indexed.

Compare: intelligent key.
Translate surrogate key to German
Browse
surrebutter
Surrein
Surrejoin
Surrejoinder
Surrender
Surrender of criminals
surrendered
Surrenderee
Surrenderer
Surrenderor
Surrendry
Surreption
Surreptitious
surreptitiously
Surrey
Surrogate
-- surrogate key --
Surrogate mother
Surrogateship
Surrogation
Surround
surrounded
Surrounding
surroundings
Surroyal
Sursanure
Surseance
Sursolid
Surstyle
Sursum corda
Surtax
surtitle
Surtout
Definitions Index: # A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

About this site and copyright information - Online Dictionary Home - Privacy Policy