Better alternative: 2.0 – use
(Re)initializes a generator or sequence to the given value. From Firebird 2 onward, the SQL-compliant
ALTER SEQUENCE syntax is preferred.
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
NEXT VALUE FOR) unless you know exactly what you are doing.