SYSDEPENDS system table

The SYSDEPENDS table stores the dependency relationships between persistent objects in the database.

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.

Table 1. 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