Error 1000283

"Identity/Autoincrement Column value range exceeded for column %2. %1"

Item Description

SQLCode

-1000283L

Constant

EMSG_IDENTITY_EXCEEDS_RANGE

SQLState

QDC65

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

20030

Severity Code

14

Parameter 1

location of the exception

Parameter 2

column name

Probable cause

Data overflow: An Identity/Autoincrement Column has reached its maximum value. To correct this create a new table in which the datatype of the new Identity/Autoincrement Column is larger and copy this table into the new table. Alternatively add a new Identity/Autoincrement Column to the table with a larger datatype and delete the old one.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com