D.18 RDB$GENERATORS

RDB$GENERATORS stores generators (sequences) and keeps them up-to-date.

Column Name Data Type Description
RDB$GENERATOR_NAME CHAR(63) The unique name of the generator
RDB$GENERATOR_ID SMALLINT The unique identifier assigned to the generator by the system
RDB$SYSTEM_FLAG SMALLINT Flag: 0 - user-defined 1 or greater - system-defined 6 - internal generator for identity column
RDB$DESCRIPTION BLOB TEXT Could store comments related to the generator
RDB$SECURITY_CLASS CHAR(63) May reference a security class defined in the table RDB$SECURITY_CLASSES, in order to apply access control limits to all users of this generator
RDB$OWNER_NAME CHAR(63) The user name of the user who created the generator originally
RDB$INITIAL_VALUE BIGINT Stores the initial value (START WITH value) of the generator
RDB$GENERATOR_INCREMENT INTEGER Stores the increment of the value (INCREMENT BY value) of the generator