| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| CONSTNAME |
VARCHAR(128) NOT NULL |
Name of the constraint. |
G |
| TBCREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the table on which the constraint is defined. |
G |
| TBNAME |
VARCHAR(18) NOT NULL |
Name of the table on which the constraint is defined. |
G |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID under which the constraint was created. |
G |
| TYPE |
CHAR(1) NOT NULL |
Type of constraint:
P Primary key
U Unique key |
G |
| IXOWNER |
CHAR(8) NOT NULL |
Owner of the index enforcing the constraint or blank if index has not been created
yet. |
G |
| IXNAME |
VARCHAR(18) NOT NULL |
Name of the index enforcing the constraint or blank if index has not been created
yet. |
G |
| CREATEDTS |
TIMESTAMP NOT NULL |
Time when the statement to create the constraint was executed. |
G |
| IBMREQD |
CHAR(1) NOT NULL
WITH DEFAULT 'N' |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
| COLCOUNT |
SMALLINT NOT NULL |
Number of columns in the constraint |
G |
