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 |
Previous Page
Next Page
Table of Contents
Index