SYSCAT.TABCONST catalog view
Each row represents a table constraint of type CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY. For table hierarchies, each constraint is recorded only at the level of the hierarchy where the constraint was created.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
CONSTNAME | VARCHAR (128) | Name of the constraint. | |
TABSCHEMA | VARCHAR (128) | Schema name of the table to which this constraint applies. | |
TABNAME | VARCHAR (128) | Unqualified name of the table to which this constraint applies. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the constraint. | |
OWNERTYPE | CHAR (1) |
|
|
TYPE | CHAR (1) | Indicates the constraint type.
|
|
ENFORCED | CHAR (1) |
|
|
TRUSTED | CHAR (1) | If ENFORCED = 'N', specifies whether the data can be trusted
to conform to the constraint.
|
|
CHECKEXISTINGDATA | CHAR (1) |
|
|
ENABLEQUERYOPT | CHAR (1) |
|
|
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the constraint. | |
PERIODNAME | VARCHAR (128) | Y | Name of the period used to define this constraint. |
PERIODPOLICY | CHAR (1) | If a period name was specified, the constraint uses this period
policy.
|
|
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|