Alternate Key
It is commonplace in SQL databases to declare a single primary key, the most important unique key. However, there could be further unique keys that could serve the same purpose. These should be marked as 'unique' keys. This is done to prevent incorrect data from entering a table (a duplicate entry is not valid in a unique column) and to make the database more complete and useful. These could be called alternate keys.
Read more about this topic: Unique Key
Famous quotes containing the words alternate and/or key:
“It might become a wheel spoked red and white
In alternate stripes converging at a point
Of flame on the line, with a second wheel below,
Just rising, accompanying, arranged to cross,
Through weltering illuminations, humps
Of billows, downward, toward the drift-fire shore.”
—Wallace Stevens (1879–1955)
“All meanings, we know, depend on the key of interpretation.”
—George Eliot [Mary Ann (or Marian)