db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "SystemTables" by MamtaSatoor
Date Wed, 31 May 2006 19:19:17 GMT
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

Mime
View raw message