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.
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. 1 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. 1 false A system type that describes the table, conglomerate, constraint, and privilege that is the provider