SYSFILES system table The SYSFILES table describes jar files stored in the database. system tablesSYSFILES jar filesSYSFILES system table SYSFILES system table

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

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.