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:
“In museums and palaces we are alternate radicals and conservatives.”
—Henry James (1843–1816)
“Now narrow minds can develop as well through persecution as through benevolence; they can assure themselves of their power by tyrannizing cruelly or beneficently over others; they go the way their nature guides them. Add to this the guidance of interest, and you will have the key to most social riddles.”
—Honoré De Balzac (1799–1850)