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