RDB$GENERATORS

Reserved Words and KeywordsMonitoring Tables

`RDB$GENERATORS`

RDB$GENERATORS stores the metadata of sequences (generators).

Column Name Data Type Description

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`, to apply access control limits to all users of this generator
`RDB$OWNER_NAME`	`CHAR(63)`	The username 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

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-defined6 - 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, to apply access control limits to all users of this generator

RDB$OWNER_NAME

CHAR(63)

The username 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

`RDB$INDEX_SEGMENTS`

RDB$INDEX_SEGMENTS stores the segments (table columns) of indexes and their positions in the key.A separate row is stored for each column in an index.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$INDEX_NAME`	`CHAR(63)`	The name of the index this segment is related to.The master record is `RDB$INDICES.RDB$INDEX_NAME`.
`RDB$FIELD_NAME`	`CHAR(63)`	The name of a column belonging to the index, corresponding to an identifier for the table and that column in `RDB$RELATION_FIELDS.RDB$FIELD_NAME`
`RDB$FIELD_POSITION`	`SMALLINT`	The column position in the index.Positions are numbered left-to-right, starting at zero
`RDB$STATISTICS`	`DOUBLE PRECISION`	The last known (calculated) selectivity of this column in the index.The higher the number, the lower the selectivity.

RDB$INDEX_NAME

CHAR(63)

The name of the index this segment is related to.The master record is RDB$INDICES.RDB$INDEX_NAME.

RDB$FIELD_NAME

CHAR(63)

The name of a column belonging to the index, corresponding to an identifier for the table and that column in RDB$RELATION_FIELDS.RDB$FIELD_NAME

RDB$FIELD_POSITION

SMALLINT

The column position in the index.Positions are numbered left-to-right, starting at zero

RDB$STATISTICS

DOUBLE PRECISION

The last known (calculated) selectivity of this column in the index.The higher the number, the lower the selectivity.