Identity columns are used to store sequential numbers, such as invoice numbers or employee numbers, that are generated automatically by Adaptive Server. The value of the identity column uniquely identifies each row in a table.
identity indicates that the column has the identity property. Each table in a database can have one identity column with a datatype of integer, small integer, tiny integer or numeric with a scale of 0. Identity columns are not updatable and do not allow nulls.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
