# SYSFILES system table

The SYSFILES table describes jar files stored in the database.

The following table shows the contents of the SYSFILES system table.

Table 1. SYSFILES system table
Column Name | Type | Length | Nullable | Contents
--- | --- | --- | --- | ---
FILEID | CHAR | 36 | false | Unique identifier for the jar file
SCHEMAID | CHAR | 36 | false | ID of the jar file's schema (join with SYSSCHEMAS.SCHEMAID)
FILENAME | VARCHAR | 128 | false | SQL name of the jar file
GENERATIONID | BIGINT | 20 | false | Generation number for the file. When jar files are replaced, their generation identifiers are changed.

Parent topic: Derby system tables