2857604 - How to set the "AUTOINCREMENT default" - SQL Anywhere

This document explains how to set the "AUTOINCREMENT default". The "AUTOINCREMENT default" is useful for numeric data fields where the value of the number itself may have no meaning.

The feature assigns each new row a unique value larger than any other value in the column.
For example, you can confirm the registration order or other for the record which you have already registered.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SQL Anywhere

KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To