meta data for this page
  •  

Alternate key

Alternate key/secondary key

In addition to primary keys, it is sometimes desirable to define alternate or secondary keys, for example, in a project table where, in addition to the primary key ID field, you wish to ensure that each project name is only used once.