Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.
The following page has been changed by MamtaSatoor:
http://wiki.apache.org/db-derby/SystemTables
------------------------------------------------------------------------------
is a foreign key referring to SYSSCHEMAS.SCHEMAID.
SYSCONGLOMERATES has one row for each heap (base table) and index in
- the database. Its primary key is CONGLOMERATEID, which is a
- system-generated value. The TABLEID column is a foreign key referring
- to SYSTABLES.TABLEID. The SCHEMAID column is a foreign key referring
- to SYSSCHEMAS.SCHEMAID. The ISCONSTRAINT column tells whether the row
- represents the backing index for a primary key, foreign key or unique
- constraint.
+ the database. CONGLOMERATEID is a system-generated value. There is no
+ unique key defined on it but it contains unique values for the table.
+ The TABLEID column is a foreign key referring to SYSTABLES.TABLEID.
+ The SCHEMAID column is a foreign key referring to SYSSCHEMAS.SCHEMAID.
+ The ISCONSTRAINT column tells whether the row represents the backing
+ index for a primary key, foreign key or unique constraint.
SYSKEYS has one row for each primary key or unique constraint in the
database. Its primary key is CONSTRAINTID, which is also a foreign
|