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.
Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |