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. You can use AUTOINCREMENT columns to record purchase order numbers, to identify customer service calls or other entries where an identifying number is required.
AUTOINCREMENT columns are typically primary key columns or columns constrained to hold unique values.
You can retrieve the most recent value inserted into an AUTOINCREMENT column using the @@identity global variable.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|