Font size:

SYSCONGLOMERATES

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	false	whether or not conglomerate is a system-generated index enforcing a constraint
CONGLOMERATEID	CHAR	36	false	unique identifier for the conglomerate