RDB$GENERATOR_NAME
| CHAR(63)
| The unique name of the sequence |
RDB$GENERATOR_ID
| SMALLINT
| The unique identifier assigned to the sequence by the system |
RDB$SYSTEM_FLAG
| SMALLINT
| Flag: 0 - user-defined
1 or greater - system-defined
6 - internal sequence for identity column
|
RDB$DESCRIPTION
| BLOB TEXT
| Optional description of the sequence (comment) |
RDB$SECURITY_CLASS
| CHAR(63)
| May reference a security class defined in the table RDB$SECURITY_CLASSES, to apply access control limits to all users of this sequence |
RDB$OWNER_NAME
| CHAR(63)
| The username of the user who created the sequence originally |
RDB$INITIAL_VALUE
| BIGINT
| Stores the start value (START WITH value) of the sequence.
The start value is the first value generated by NEXT VALUE FOR after a restart of the sequence. |
RDB$GENERATOR_INCREMENT
| INTEGER
| Stores the increment (INCREMENT BY value) of the sequence.
The increment is used by NEXT VALUE FOR, but not by GEN_ID. |