Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).


Specifies whether this index defines the primary key for the table.


To specify that the primary key for this table is formed by the properties on which this index is based, use the following syntax:

Index name On property_expression_list [ PrimaryKey ];

Otherwise, omit this keyword or place the word Not immediately before the keyword.


This keyword specifies that this index should be reported, via SQL, as being the primary key for this class (table).

A PrimaryKey index also behaves like a unique index. That is, for the property (or the combination of properties) that you use in this index, Caché enforces uniqueness. It is permitted, but redundant, to specify the Unique keyword as true in this index definition.


Index EmpIDX On EmployeeID [ PrimaryKey] ;
Copy code to clipboard


If you omit this keyword, the primary key for this table is not formed by the properties on which this index is based.

See Also

FeedbackOpens in a new window