D.17. RDB$GENERATORS

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

Column NameData TypeDescription

RDB$GENERATOR_NAME

CHAR(31)

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(31)

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(31)

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