Each row represents a referential integrity (foreign key) constraint.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
CONSTNAME | VARCHAR (128) | Name of the constraint. | |
TABSCHEMA | VARCHAR (128) | Schema name of the dependent table. | |
TABNAME | VARCHAR (128) | Unqualified name of the dependent table. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the constraint. | |
OWNERTYPE | CHAR (1) |
|
|
REFKEYNAME | VARCHAR (128) | Name of the parent key. | |
REFTABSCHEMA | VARCHAR (128) | Schema name of the parent table. | |
REFTABNAME | VARCHAR (128) | Unqualified name of the parent table. | |
COLCOUNT | SMALLINT | Number of columns in the foreign key. | |
DELETERULE | CHAR (1) | Delete rule.
|
|
UPDATERULE | CHAR (1) | Update rule.
|
|
CREATE_TIME | TIMESTAMP | Time at which the constraint was defined. | |
FK_COLNAMES | VARCHAR (640) | This column is no longer used and will be removed in a future release. Use SYSCAT.KEYCOLUSE for this information. | |
PK_COLNAMES | VARCHAR (640) | This column is no longer used and will be removed in a future release. Use SYSCAT.KEYCOLUSE for this information. | |
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the constraint. | |
Note:
|