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. system tablesSYSCONGLOMERATES conglomeratesSYSCONGLOMERATES system table SYSCONGLOMERATES system table

The following table shows the contents of the SYSCONGLOMERATES system table.

SYSCONGLOMERATES system tableFor each column in the SYSCONGLOMERATES system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. 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