| Firebird Documentation Index → Firebird 2.0 Language Ref. Update → DDL statements → SET GENERATOR |
|
|
|
Available in: DSQL, ESQL
Better alternative: ALTER SEQUENCE
Description: (Re)initializes a generator or sequence to the given value. From Firebird 2 onward, the SQL-compliant ALTER SEQUENCE syntax is preferred.
Syntax:
SET GENERATORgenerator-nameTO<new-value><new-value>::= A 64-bit integer.
Once a generator or sequence is up and running, you should not tamper with its value (other than retrieving next values with GEN_ID or NEXT VALUE FOR) unless you know exactly what you are doing.
|
| Firebird Documentation Index → Firebird 2.0 Language Ref. Update → DDL statements → SET GENERATOR |