Contains a row for each defined referential constraint.
Table 84. SYSCAT.REFERENCES Catalog View
Column Name | Data Type | Nullable | Description | ||
---|---|---|---|---|---|
CONSTNAME | VARCHAR(18) |
| Name of constraint. | ||
TABSCHEMA | CHAR(8) |
| Qualified name of the constraint. | ||
TABNAME | VARCHAR(18) |
| |||
DEFINER | CHAR(8) |
| User who created the constraint. | ||
REFKEYNAME | VARCHAR(18) |
| Name of parent key. | ||
REFTABSCHEMA | CHAR(8) |
| Name of the parent table. | ||
REFTABNAME | VARCHAR(18) |
| |||
COLCOUNT | SMALLINT |
| Number of columns in the foreign key. | ||
DELETERULE | CHAR(1) |
| Delete rule:
A=NO ACTION C=CASCADE N=SET NULL R=RESTRICT | ||
UPDATERULE | CHAR(1) |
| Update rule:
A=NO ACTION R=RESTRICT | ||
CREATE_TIME | TIMESTAMP |
| The timestamp when the referential constraint was defined. | ||
FK_COLNAMES | VARCHAR(320) |
| List of foreign key column names. | ||
PK_COLNAMES | VARCHAR(320) |
| List of parent key column names. | ||
|