Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → CREATE GENERATOR
Firebird Home Firebird Home Prev: CREATE EXCEPTIONFirebird Documentation IndexUp: DDL statementsNext: CREATE INDEX

CREATE GENERATOR

CREATE SEQUENCE preferred
Maximum number of generators significantly raised

Available in: DSQL, ESQL

Better alternative: 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.

Prev: CREATE EXCEPTIONFirebird Documentation IndexUp: DDL statementsNext: CREATE INDEX
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → CREATE GENERATOR