RDB$FIELD_DIMENSIONS

`RDB$FIELD_DIMENSIONS`

RDB$FIELD_DIMENSIONS stores the dimensions of array columns.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$FIELD_NAME`	`CHAR(63)`	The name of the array column.It must be present in the `RDB$FIELD_NAME` field of the `RDB$FIELDS` table
`RDB$DIMENSION`	`SMALLINT`	Identifies one dimension in the array column.The numbering of dimensions starts with 0
`RDB$LOWER_BOUND`	`INTEGER`	The lower bound of this dimension
`RDB$UPPER_BOUND`	`INTEGER`	The upper bound of this dimension

RDB$FIELD_NAME

CHAR(63)

The name of the array column.It must be present in the RDB$FIELD_NAME field of the RDB$FIELDS table

RDB$DIMENSION

SMALLINT

Identifies one dimension in the array column.The numbering of dimensions starts with 0

RDB$LOWER_BOUND

INTEGER

The lower bound of this dimension

RDB$UPPER_BOUND

INTEGER

The upper bound of this dimension

RDB$FILES stores information about secondary files and shadow files.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$FILE_NAME`	`VARCHAR(255)`	The full path to the file and the name of either the database secondary file in a multi-file database, or the shadow file
`RDB$FILE_SEQUENCE`	`SMALLINT`	The sequential number of the secondary file in a sequence or of the shadow file in a shadow file set
`RDB$FILE_START`	`INTEGER`	The initial page number in the secondary file or shadow file
`RDB$FILE_LENGTH`	`INTEGER`	File length in database pages
`RDB$FILE_FLAGS`	`SMALLINT`	For internal use
`RDB$SHADOW_NUMBER`	`SMALLINT`	Shadow set number.If the row describes a database secondary file, the field will be `NULL` or its value will be 0

RDB$FILE_NAME

VARCHAR(255)

The full path to the file and the name of either

RDB$FILE_SEQUENCE

SMALLINT

The sequential number of the secondary file in a sequence or of the shadow file in a shadow file set

RDB$FILE_START

INTEGER

The initial page number in the secondary file or shadow file

RDB$FILE_LENGTH

INTEGER

File length in database pages

RDB$FILE_FLAGS

SMALLINT

For internal use

RDB$SHADOW_NUMBER

SMALLINT

Shadow set number.If the row describes a database secondary file, the field will be NULL or its value will be 0