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