| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the dependent table of the referential
constraint. |
G |
| TBNAME |
VARCHAR(18) NOT NULL |
Name of the dependent table of the referential constraint. |
G |
| RELNAME |
CHAR(8) NOT NULL |
Constraint name |
G |
| REFTBNAME |
VARCHAR(18) NOT NULL |
Name of the parent table of the referential constraint. |
G |
| REFTBCREATOR |
SMALLINT NOT NULL |
Authorization ID of the owner of the parent table. |
G |
| COLCOUNT |
CHAR(8) NOT NULL |
Number of columns in the foreign key. |
G |
| DELETERULE |
CHAR(1) NOT NULL |
Type of delete rule for the referential constraint.
C CASCADE
N SET NULL
R RESTRICT
A NO ACTION
|
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM)
tape:
N No
Y Yes |
S |
| RELOBID1 |
SMALLINT NOT NULL
WITH DEFAULT |
Internal identifier of the constraint with respect to the database that
contains the parent table. |
S |
| RELOBID2 |
SMALLINT NOT NULL
WITH DEFAULT |
Internal identifier of the constraint with respect to the database that
contains the dependent table. |
S |
| TIMESTAMP |
TIMESTAMP NOT NULL
WITH DEFAULT |
The date and time the constraint was defined. If the constraint is
between catalog tables prior to DB2 Version 2 Release 3, the value is
'1985-04-01-00.00.00.000000.' :epsc.. |
G |
| IXOWNER |
CHAR(8) NOT NULL
WITH DEFAULT |
Owner of unique non-primary index used for the parent key. '99999999' if
the enforcing index has been dropped. Blank if the enforcing index is a
primary index. |
G |
| IXNAME |
VARCHAR(18) NOT NULL
WITH DEFAULT |
Name of unique non-primary index used for a parent key. '99999999' if
the enforcing index has been dropped. Blank if the enforcing index is a
primary index. |
G |
