# 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 1. 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

Parent topic: Derby system tables