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
For each column in the SYSDEPENDS 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
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