CREATE GENERATOR

<< CREATE SEQUENCE | FB 2.5 Language Reference | ALTER SEQUENCE >>
<< CREATE SEQUENCE | FB 2.1 Language Reference | ALTER SEQUENCE >>
<< CREATE EXCEPTION | FB 2.0 Language Reference | CREATE INDEX >>

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.

See also:
CREATE SEQUENCE
GEN_ID( )
SET GENERATOR
DROP GENERATOR
DDL - Data Definition Language

back to top of page
<< CREATE SEQUENCE | FB 2.5 Language Reference | ALTER SEQUENCE >>
<< CREATE SEQUENCE | FB 2.1 Language Reference | ALTER SEQUENCE >>
<< CREATE EXCEPTION | FB 2.0 Language Reference | CREATE INDEX >>