surrogate key

created by WWWWolf
(thing) by WWWWolf (1.6 y) (print)   (I like it!) Mon Dec 04 2000 at 16:15:21

In RDBMSes, a surrogate key is a key for database row that is unique for each row and is not derived from the row data. Surrogates should also be same for same data "forever" - if a row gets removed, and is added again later, it should get the same surrogate key (this should be derived from key values).

Surrogates are used internally by RDBMS to associate data with identifiers; usually these are not even seen by the users of the database.

Y'know, if you log in, you can write something here, or contact authors directly on the site. Create a New User if you don't already have an account.