Error 1510

"Cannot specify range that excludes next value for sequence %1"

Item Description

SQLCode

-1510L

Constant

INVALID_ALTER_SEQUENCE

SQLState

52W54

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

3178

Severity Code

16

Parameter 1

Name of the sequence.

Probable cause

You attempted to modify either the MINVAL or MAXVAL boundary of a sequence to a value that would make the next invocation of the nextval expression for the sequence invalid. If you want to change the range boundaries to these values, you must also specify a RESTART WITH clause and supply a value within the new range.


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