SYSFOREIGNKEYS catalog table
The SYSFOREIGNKEYS table contains one row for every column of every foreign key. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| CREATOR | VARCHAR(128)
NOT NULL |
Schema or qualifier of the table that contains the column. | G |
| TBNAME | VARCHAR(128)
NOT NULL |
Name of the table that contains the column. | G |
| RELNAME | VARCHAR(128)
NOT NULL |
Constraint name for the constraint for which the column is part of the foreign key. | G |
| COLNAME | VARCHAR(128)
NOT NULL |
Name of the column. | G |
| COLNO | SMALLINT
NOT NULL |
Numeric place of the column in its table. | G |
| COLSEQ | SMALLINT
NOT NULL |
Numeric place of the column in the foreign key. | 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. |
G |