SYSFILES system table
Derby Reference Manual
226
Column Name
Type
Length
Nullable
Contents
This class is not
part of the public
API.
trigger that is the
dependent
PROVIDERID
CHAR
36
false
A unique identifier
for the provider
PROVIDERFINDER
org.apache.derby.
catalog.
DependableFinder
This class is not
part of the public
API.
2,147,483,647
false
A system type that
describes the table,
conglomerate,
constraint, and
privilege that is the
provider
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 48.
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.
SYSFOREIGNKEYS system table
The SYSFOREIGNKEYS table describes the information specific to foreign key
constraints in the current database.
Derby generates a backing index for each foreign key constraint. The name of this index
is the same as SYSFOREIGNKEYS.CONGLOMERATEID.
The following table shows the contents of the SYSFOREIGNKEYS system table.
Table 49.
SYSFOREIGNKEYS system table
