CREATE GENERATOR

Table of Contents

CREATE SEQUENCE preferred
Maximum number of generators significantly raised

Tip

Find a more recent version at Firebird 5.0 Language Reference: SEQUENCE (GENERATOR)

Available in: DSQL, ESQL

Better alternative: CREATE SEQUENCE

CREATE SEQUENCE preferred

Tip

Find a more recent version at Firebird 5.0 Language Reference: SEQUENCE (GENERATOR)

Changed in: 2.0

Description: From Firebird 2.0 onward, the SQL-compliant CREATE SEQUENCE syntax is preferred.

Maximum number of generators significantly raised

Changed in: 1.0

Description: InterBase reserved only one database page for generators, limiting the total number to 123 (on 1K pages) – 1019 (on 8K pages). Firebird has done away with that limit; you can now create more than 32,000 generators per database.