apache > db
Apache DB Project
 
Font size:      

SYSFOREIGNKEYS

SYSFOREIGNKEYS

Describes the information specific to foreign key constraints in the current database.

Derby generates a backing index for each foreign key constraint; the name of this index is the same as SYSFOREIGNKEYS.CONGLOMERATEID.

Column NameTypeLengthNullabilityContents
CONSTRAINTIDCHAR36falseunique identifier for the foreign key constraint (join with SYSCONSTRAINTS. CONSTRAINTID)
CONGLOMERATEIDCHAR36falseunique identifier for index backing up the foreign key constraint (join with SYSCONGLOMERATES. CONGLOMERATEID)
KEYCONSTRAINTIDCHAR36falseunique identifier for the primary key or unique constraint referenced by this foreign key (SYSKEYS.CONSTRAINTID or SYSCONSTRAINTS. CONSTRAINTID)
DELETERULECHAR1falseR for NO ACTION (default), S for RESTRICT, C for CASCADE, U for SET NULL
UPDATERULECHAR1falseR for NO ACTION(default), S for restrict

Previous Page
Next Page
Table of Contents
Index