Creating Models › Creating a Physical Model › Indexes › Alternate Key Indexes

Alternate Key Indexes

A unique, or alternate key (AK), index is an index on a set of columns in a particular table other than the primary key column set. Duplicate values in the indexed columns are not allowed.

In a logical/physical model, if you create, at the logical level, an Alternate Key key group that uses one or more columns in a table, the corresponding unique index is automatically created for the table. At the physical level, you can use the Table Index Editor to create a unique index on a table. The default name for a unique index is XAKnTableName, as specified by the IndexName macro.