[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
SYSFOREIGNKEYS
Describes the information specific to foreign key constraints in the current database.
Cloudscape generates a backing index for each foreign key constraint; the name of this index is the same as SYSFOREIGNKEYS.CONGLOMERATEID.
Column Name |
Type |
Length |
Nullability |
Contents |
CONSTRAINTID |
CHAR |
36 |
false |
unique identifier for the foreign key constraint (join with SYSCONSTRAINTS. CONSTRAINTID) |
CONGLOMERATEID |
CHAR |
36 |
false |
unique identifier for index backing up the foreign key constraint (join with SYSCONGLOMERATES. CONGLOMERATEID) |
KEYCONSTRAINTID |
CHAR |
36 |
false |
unique identifier for the primary key or unique constraint referenced by this foreign key (SYSKEYS.CONSTRAINTID or SYSCONSTRAINTS.-- CONSTRAINTID) |
DELETERULE |
CHAR |
1 |
false |
R for restrict |
UPDATERULE |
CHAR |
1 |
false |
R for restrict |
Indexes
- SYSFOREIGNKEYS_INDEX1 unique BTREE index on (CONSTRAINTID)
- SYSFOREIGNKEYS_INDEX2 BTREE index on (KEYCONSTRAINTID)
|