docs.intersystems.com
Caché Class Definition Reference
Identity
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Search:    

Specifies whether this property corresponds to the identity column in the corresponding SQL table. Applies to persistent classes.
Usage
To specify that this property corresponds to the identity column in the corresponding SQL table, use the following syntax:
Property name As %Integer [ Identity ];
Note:
The type of the property can be any integer type, for example, %BigInt, %Integer, %SmallInt, or %TinyInt.
Otherwise, omit this keyword or place the word Not immediately before the keyword.
Details
For a persistent object, this keyword specifies that a property corresponds to an identity column in the corresponding SQL table (that is, a column that is marked with the SQL IDENTITY keyword). This keyword is useful particularly for tables that are created through DDL statements. When creating a table using DDL, make sure that any IDENTITY field is defined with MINVAL=1, if possible, to allow the creation of a bitmap extent index. See CREATE TABLE in the Caché SQL Reference.
Default
If you omit this keyword, this property is not used as the identity column.
See Also


Send us comments on this page
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA