SYSDEPENDS system table
Derby Reference Manual
225
Column Name
Type
Length
Nullable
Contents
CONSTRAINTID
CHAR
36
false
Unique identifier for
constraint
TABLEID
CHAR
36
false
Identifier for table
(join with SYSTABLES.TABLEID)
CONSTRAINTNAME
VARCHAR
128
false
Constraint
name (internally
generated if not
specified by user)
TYPE
CHAR
1
false
'P' (primary key),
'U' (unique), 'C'
(check), or 'F'
(foreign key)
SCHEMAID
CHAR
36
false
Identifier for
schema that the
constraint belongs
to (join with SYSSCHEMAS.SCHEMAID)
STATE
CHAR
1
false
'E' for enabled, 'D'
for disabled
REFERENCECOUNT
INTEGER
10
false
The count of the
number of foreign
key constraints
that reference this
constraint; this
number can be
greater than zero
only for PRIMARY
KEY and UNIQUE
constraints
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 47.
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
2,147,483,647
false
A system type
that describes the
view, constraint, or
