Identity Column (Magic xpa 2.x)

Columns that have the IDENTITY property contain system-generated values that uniquely identify each row within a table. This is used to generate sequential numbers (for example, employee identification numbers). When inserting values into a table with an identity column, Pervasive automatically generates the next identifier based on the last used identity value (incremented by adding rows)

This was implemented in the Magic xpa Pervasive gateway, in the following way:

• A column will be identified as an IDENTITY column by specifying the keyword IDENTITY in the Type Property in the SQL Tab of the Column Properties. This will be done by the Magic xpa programmer (if the table is created from Magic xpa).