SYSFOREIGNKEYS system table The SYSFOREIGNKEYS table describes the information specific to foreign key constraints in the current database. system tablesSYSFOREIGNKEYS foreign key constraintsSYSFOREIGNKEYS system table SYSFOREIGNKEYS system table

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

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

SYSFOREIGNKEYS system tableFor each column in the SYSFOREIGNKEYS 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 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 NO ACTION (default), 'S' for RESTRICT, 'C' for CASCADE, 'U' for SET NULL UPDATERULE CHAR 1 false 'R' for NO ACTION (default), 'S' for RESTRICT