meta data for this page
  •  

CREATE GENERATOR

Available in: DSQL, ESQL

Better alternative: 2.0 – use CREATE SEQUENCE

CREATE SEQUENCE preferred

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.