REFER_CONSTRAINTS
Records referential constraints in the database.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table. |
CONSTRAINT_SYSID
|
INTEGER
|
System identifier for the referential constraint. |
UNIQUE_TABLE_SYSID
|
INTEGER
|
System identifier for the table that is referenced in the foreign key. |
UNIQUE_CONST_SYSID
|
INTEGER
|
System identifier for the constraint that is (implicitly) referenced in the foreign key. |
MATCH_OPTION
|
CHAR(20)
|
One of:
"NONE"
"PARTIAL"
"FULL". |
UPDATE_RULE
|
CHAR(20)
|
One of:
"CASCADE"
"SET NULL"
"SET DEFAULT"
"NO ACTION"
"RESTRICT". |
DELETE_RULE
|
CHAR(20)
|
One of:
"CASCADE"
"SET NULL"
"SET DEFAULT"
"NO ACTION"
"RESTRICT". |
Primary key: TABLE_SYSID, CONSTRAINT_SYSID
Secondary index: UNIQUE_TABLE_SYSID, UNIQUE_CONST_SYSID
