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.

 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
Parent topic: Derby system tables