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. | ||
| |||||