version column

A column incremented on every update, used to detect that a row changed between read and write.

In more detail

An update includes the version it read in its condition; if another writer got there first, no row matches and the write is rejected. This is the optimistic guard against lost updates.

Related terms

Taught in

References