InterSystems IRIS Data Platform 2019.2  /  Class Definition Reference

Class Definition Reference
Previous section          
InterSystems: The power behind what matters   

Specifies whether the index should enforce uniqueness.
To specify that InterSystems IRIS should enforce uniqueness for the properties on which this index is based, use the following syntax:
Index name On property_expression_list [ Unique ];
Otherwise, omit this keyword or place the word Not immediately before the keyword.
The Unique keyword, if present, indicates that this is a unique index.
The property (or properties) indexed by a unique index are constrained to have unique values (that is, no two instances can have the same collated value) within the extent (set of all objects) of the class (table) that defines the index.
A unique index cannot also be a bitmap index.
Index SSNIdx On SSN [ Unique ] ;
If you omit this keyword, InterSystems IRIS does not enforce uniqueness for the properties on which this index is based.
See Also

Previous section          
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-08-20 05:45:45