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 tableFor each column in the SYSFILES system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. 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.