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