The DB Access Module for MySQL supports identity columns with the keyword AUTO_INCREMENT, but does not support any identity attributes. The module ignores any identity attributes set on RWDBIdentityConstraint while creating tables.

When fetching a table schema, an identity column will have a valid RWDBIdentityConstraint object, but it will not have any attributes set on it.

The MySQL database requires that an AUTO_INCREMENT column be included in the table's primary key; further, it does not support a decimal type column to be defined as an AUTO_INCREMENT column. SourcePro DB does not enforce these requirements in any way nor does it implicitly include an AUTO_INCREMENT column in the table's primary key. The database server will return an error if these requirements are not met.

For examples creating identity constraints, see Section 4.5.2.3, “Identity Column Constraints,” in the DB Interface Module User's Guide.