Describes the conglomerates within the current database. A conglomerate
is a unit of storage and is either a table or an index.
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
8
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.
true
system type describing the index
ISCONSTRAINT
BOOLEAN
1
true
whether or not conglomerate is a system-generated index
enforcing a constraint
CONGLOMERATEID
CHAR
36
false
unique identifier for the conglomerate