Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → SET GENERATOR
Firebird Home Firebird Home Prev: REVOKE ADMIN OPTIONFirebird Documentation IndexUp: DDL statementsNext: DML statements

SET GENERATOR

Tip

Find a more recent version at Firebird 5.0 Language Reference: SEQUENCE (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 GENERATOR generator-name TO <new-value>

<new-value>  ::=  A 64-bit integer.

Warning

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.

Prev: REVOKE ADMIN OPTIONFirebird Documentation IndexUp: DDL statementsNext: DML statements
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → SET GENERATOR