# 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

Parent topic: Derby system tables