SQLData object identity columns

The identity (or primary key) column is used for record navigation, selected record access, and unique identification of records affected by bad data quality. You can specify the identity (or primary key) column name when you create a new database; however, once you have saved the column name to the database, you cannot modify the name.

When you connect to an existing database, the identity (or primary key) column name is automatically read into the Identity Column Name box. If the column name does not exist in the database table, the Identity Column Name box defaults to "aa_id," (but remains enabled for editing) and the Modify Database button becomes available. If the database configuration is not written to the database during configuration (that is, the Modify Database button is not clicked), the object adds the column name to the database when the object is deployed.

The identity (or primary key) column must be a unique column name in the database table. The constraint is saved in the database as Tablename.IdentityColumnName to ensure the column name is unique within the database. The identity (or primary key) column does not appear in the database preview.

If the identity (or primary key) column name is blank, the object will error.