 |
» |
|
|
|
SYSTEM.CHECKDEF contains check constraint definitions.
Initially, the table is empty. ALLBASE/SQL updates
this table when processing a
CREATE TABLE, ALTER TABLE, DROP TABLE, or
TRANSFER OWNERSHIP statement involving a check constraint. The text of the table check constraint comprising the search condition is
stored in this table for each check constraint along with the constraint
owner and constraint name. All other information about this constraint is
in SYSTEM.CONSTRAINT. SQLGEN also uses this table for recreating a CREATE TABLE statement
containing check constraints. Table 8-4 System.CheckDef |
Column Name
|
Type
|
Length
|
Description |
|---|
| CONSTRAINTNAME | CHAR | 20 | Name of the constraint | | OWNER | CHAR | 20 | Owner of the constraint | | COLUMNNAME | CHAR | 20 | Column to which the constraint applies | | SEGNUM | INTEGER | 4 | Segment number | | SEGLEN | INTEGER | 4 | Length of segment in bytes | | CONDITIONSTRING | CHAR | 64 | Check constraint string segment
|
Example | |
select constraintname, owner, columnname from system.checkdef;
--------------------+--------------------+--------------------
CONSTRAINTNAME |OWNER |COLUMNNAME
--------------------+--------------------+--------------------
SQLCON_00090000200 |PURCHDB |
---------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]>
select segnum, seglen, conditionstring from system.checkdef;
-----------+-----------+--------------------------------------------------------
SEGNUM |SEGLEN |CONDITIONSTRING
-----------+-----------+--------------------------------------------------------
1| 14|salesprice> 0
---------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]>
|
|
