Physical Modeling › Indexes › Primary Key Indexes

Primary Key Indexes

A primary key (PK) index is an index on the primary key columns in a particular table.

A single table can have only one primary key index. A primary key index is unique, so the indexed columns cannot have duplicate values. A primary key index is automatically created for each table that has one or more primary key columns. The default name for a primary key index is XPKTableName, as specified by the IndexName macro.