Skip to main content
Previous sectionNext section

Identity

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 ];
Copy code to clipboard
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 InterSystems SQL Reference.

Default

If you omit this keyword, this property is not used as the identity column.

See Also