RDB$FILES

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.