AutoIncrement Property

Sets whether the field value should be automatically incremented.

Applies To

Fields of Integer Data Type and BigInteger Data Type

Property Value

Yes if the field value is automatically incremented; otherwise, No. The default value is Yes.

Note

If you want to manually assign a value to a field that has the AutoIncrement property set to Yes, you must be member of the SQL Server db_owner database permission set.

Remarks

A table can only contain one auto-increment field. The numbers assigned to this field will not always be consecutive for the following reasons:

  • If you delete some records from a table, the numbers used for these records are not reused.

  • If several transactions are performed at the same time, they will each be assigned a different number. However, if one of these transactions is rolled back, the number that it was assigned is not reused.

If you add an auto-increment field to an existing table, the field automatically generates consecutive values and inserts them into the table. If you enable the AutoIncrement property for a field that already contains data, there must be no zero values in the field.

The AutoIncrement property is designed to always assign numbers automatically. If you want to insert a record, be sure that the value in this field is blank before you insert the record.

The AutoIncrement property does not work with Microsoft Dynamics NAV temporary tables.

See Also

Concepts

Properties