SYSCONGLOMERATES system table

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