The HSSYSFKE table is used for SYSFOREIGNKEYS views. The following table describes the columns in the HSSYSFKE table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| CREATOR | VARCHAR | 128 | 0 | Schema or qualifier of the table that contains the column |
| TBNAME | VARCHAR | 128 | 0 | Name of the table on contains the column |
| RELNAME | VARCHAR | 128 | 0 | Constraint name for the constraint for which the column is part of the foreign key |
| COLNAME | VARCHAR | 128 | 0 | Name of the column |
| COLNO | SMALLINT | 4 | 0 | Numeric place of the column in its table |
| COLSEQ | SMALLINT | 4 | 0 | Numeric place of the column in the foreign key |
| IBMREQD | CHAR | 1 | 0 |