HSSYSREL

The HSSYSREL table is used for SYSRELS views. The following table describes the columns in the HSSYSREL table:

Column Type Length Decimal Domain
CREATOR VARCHAR 128 0 The schema of the dependent table of the referential constraint
TBNAME VARCHAR 128 0 Name of the dependent table of the referential constraint
RELNAME VARCHAR 128 0 Constraint name
REFTBNAME VARCHAR 128 0 Name of the parent table of the referential constraint
REFTBCREATOR VARCHAR 128 0 The schema of the parent table
COLCOUNT SMALLINT 4 0 Number of columns in the foreign key
DELETERULE CHAR 1 0 Type of delete rule for the referential constraint
IBMREQD CHAR 1 0
RELOBID1 SMALLINT 4 0 Internal identifier of the constraint with respect to the database that contains the parent table
RELOBID2 SMALLINT 4 0 Internal identifier of the constraint with respect to the database that contains the parent table
TIMESTAMP TIMESTAMP 26 0 Date and time the constraint was defined
IXOWNER VARCHAR 128 0 The schema of unique non-primary index used for the parent key
IXNAME VARCHAR 128 0 Name of unique non-primary index used for a parent key