D.13 RDB$FILES

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

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