SYSRELS catalog table

The SYSRELS table contains one row for every referential constraint. The schema is SYSIBM.

Table 1. SYSIBM.SYSRELS table column descriptions
Column name Data type Description Use
CREATOR
VARCHAR(128)
NOT NULL

The schema of the dependent table of the referential constraint.

 G
TBNAME
VARCHAR(128)
NOT NULL
 Name of the dependent table of the referential constraint. G
RELNAME
VARCHAR(128)
NOT NULL
 Constraint name. G
REFTBNAME
VARCHAR(128)
NOT NULL
 Name of the parent table of the referential constraint. G
REFTBCREATOR
VARCHAR(128)
NOT NULL

The schema of the parent table.

 G
COLCOUNT
SMALLINT
NOT NULL
 Number of columns in the foreign key. G
DELETERULE
CHAR(1)
NOT NULL
 Type of delete rule for the referential constraint:
A
NO ACTION
C
CASCADE
N
SET NULL
R
RESTRICT
 G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead.

 G
RELOBID1
SMALLINT
NOT NULL WITH
DEFAULT
 Internal identifier of the constraint with respect to the database that contains the parent table. S
RELOBID2
SMALLINT
NOT NULL WITH
DEFAULT
 Internal identifier of the constraint with respect to the database that contains the dependent table. S
TIMESTAMP
TIMESTAMP
NOT NULL WITH
DEFAULT
 Date and time the constraint was defined. If the constraint is between catalog tables prior to Version 2 Release 3, the value is '1985-04-01-00.00.00.000000.'. G
IXOWNER
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Schema for a unique non-primary index used to enforce the parent key of a referential constraint.

Blank or empty string for a primary key used to enforce the parent key of a referential constraint which is a primary key.

 G
IXNAME
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Name of a unique non-primary index used to enforce the parent key of a referential constraint.

Empty string for a primary index used to enforce the parent key of a referential constraint which is a primary key.

 G
ENFORCED
CHAR(1)
NOT NULL WITH
DEFAULT 'Y"
 Enforced by the system or not:
Y
Enforced by the system
N
Not enforced by the system (trusted)
 G
CHECKEXISTINGDATA
CHAR(1)
NOT NULL WITH
DEFAULT
 Option for checking existing data:
I
Immediately check existing data. If ENFORCED = 'Y' and this is not a temporal referential constraint, this column will have a value of 'I'.
N
Never check existing data. If ENFORCED = 'N', this column will have a value of 'N'.
T
Immediately check existing data for a temporal referential constraint.
 G
RELCREATED
CHAR(1)
NOT NULL
 The release of Db2 that is used to create the object. See Release dependency indicators for the values. G