Difference between revisions of "Unique Key Index"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 9: Line 9:
:* [[Indexes#Create_an_Index|Create an Index]] ('''Enable Unique Key''' option)
:* [[Indexes#Create_an_Index|Create an Index]] ('''Enable Unique Key''' option)
:* [[Indexes#Choosing_Fields_for_Indexes|Choosing Fields for Indexes]]
:* [[Indexes#Choosing_Fields_for_Indexes|Choosing Fields for Indexes]]
<noinclude>
[[Category:Data]]
[[Category:{{features}}]]
[[Category:Objects]]
[[Category:Glossary]]
</noinclude>

Revision as of 19:40, 29 December 2011

A Unique Key Index is an index in which there are no duplicate keys. With such an index, every key points to one and only one record.

For example:

  • In a Case Management system, every case number is unique.
  • In an index of companies, every company name is unique.
  • In a list of U.S. citizens, every social security number is unique.

Learn more:

[[Category:Template:Features]]