SYSCONGLOMERATES system table
Derby Reference Manual
224
SYSCONGLOMERATES system table
The SYSCONGLOMERATES table describes the conglomerates within the current
database. A conglomerate is a unit of storage and is either a table or an index.
The following table shows the contents of the SYSCONGLOMERATES system table.
Table 45.
SYSCONGLOMERATES system table
Column Name
Type
Length
Nullable
Contents
SCHEMAID
CHAR
36
false
Schema ID for the
conglomerate
TABLEID
CHAR
36
false
Identifier for table
(join with SYSTABLES.TABLEID)
CONGLOMERATENUMBER
BIGINT
20
false
Conglomerate
ID for the
conglomerate
(heap or index)
CONGLOMERATENAME VARCHAR
128
true
Index name, if
conglomerate is an
index, otherwise
the table ID
ISINDEX
BOOLEAN
1
false
Whether or not
conglomerate is an
index
DESCRIPTOR
org.apache.derby.
catalog.
IndexDescriptor
This class is not
part of the public
API.
2,147,483,647
true
System type
describing the
index
ISCONSTRAINT
BOOLEAN
1
true
Whether or not the
conglomerate is a
system-generated
index enforcing a
constraint
CONGLOMERATEID
CHAR
36
false
Unique identifier for
the conglomerate
SYSCONSTRAINTS system table
The SYSCONSTRAINTS table describes the information common to all types of
constraints within the current database (currently, this includes primary key, unique,
foreign key, and check constraints).
The following table shows the contents of the SYSCONSTRAINTS system table.
Table 46.
SYSCONSTRAINTS system table
