RDB$FILES

From InterBase
Jump to: navigation, search

Go Up to System Tables


RDB$FILES lists the secondary files and shadow files for a database.

RDB$FILES
Column name Data type Length Description

RDB$FILE_NAME

VARCHAR

253

Names either a secondary file or a shadow file for the database.

RDB$FILE_SEQUENCE

SMALLINT

Either the order that secondary files are to be used in the database or the order of files within a shadow set.

RDB$FILE_START

INTEGER

Specifies the starting page number for a secondary file or shadow file.

RDB$FILE_LENGTH

INTEGER

Specifies the file length in blocks.

RDB$FILE_FLAGS

SMALLINT

Reserved for system use.

RDB$SHADOW_NUMBER

SMALLINT

Set number: indicates to which shadow set the file belongs; if the value of this column is 0 or missing, InterBase assumes the file being defined is a secondary file, not a shadow file.