Persistent objects can be dependents or providers. Dependents
are objects that depend on other objects. Providers are objects that other
objects depend on.
- Dependents are views, constraints, or triggers.
- Providers are tables, conglomerates, constraints, or privileges.
The following table shows the contents of the SYSDEPENDS system table.
SYSDEPENDS system table
Column Name
Type
Length
Nullable
Contents
DEPENDENTID
CHAR
36
false
A unique identifier for the dependent
DEPENDENTFINDER
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 view, constraint, or 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