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:
“Germany is a queer country: one can’t regard it dispassionately. I alternate between hating it thoroughly, stick, stock and stone, and yearning over it fit to break my heart. I can’t help feeling it a young and adorable country—adolescent—with the faults of adolescence.”
—D.H. (David Herbert)
“All meanings, we know, depend on the key of interpretation.”
—George Eliot [Mary Ann (or Marian)