Oihana Php Schema

Constraint

Property keys shared by the constraint-related OpenEdge SQL system catalog tables.

The constraint metadata is split across several tables in OpenEdge SQL:

CHECK_TEXT : string = 'checkText': SQL expression of a `CHECK` constraint (`SYS_CHK_CONSTRS.chktext`).
COLUMN : string = 'column': Column name participating in the constraint (`SYS_KEYCOL_USAGE.col` / `SYS_CHKCOL_USAGE.col`).
CONSTRAINT_NAME : string = 'constraintName': Name of the constraint (`constrname`).
CONSTRAINT_OWNER : string = 'constraintOwner': Owner (SQL schema) of the constraint (`constrowner`).
CONSTRAINT_TYPE : string = 'constraintType': Constraint type (`constrtype`): `P` (primary key), `U` (unique), `F` (foreign key) or `C` (check).
DEFERRABILITY : string = 'deferrability': Deferrability mode of the constraint (`deferrability`).
DELETE_RULE : string = 'deleteRule': `DELETE` referential action (`delete_rule`): `C` (cascade), `N` (set null), `D` (set default), `R` (restrict) or `A` (no action).
KEY_SEQUENCE : string = 'keySequence': Position of the column within a multi-column key (`keyseq`).
MATCH_TYPE : string = 'matchType': `MATCH` mode of a referential constraint (`match_type`).
UNIQUE_NAME : string = 'uniqueName': Identifier of the unique/primary key constraint referenced by a foreign key (`uniquename`).
UNIQUE_OWNER : string = 'uniqueOwner': Owner (SQL schema) of the referenced unique/primary key constraint (`uniqueowner`).
UPDATE_RULE : string = 'updateRule': `UPDATE` referential action (`update_rule`): `C` (cascade), `N` (set null), `D` (set default), `R` (restrict) or `A` (no action).

SQL expression of a `CHECK` constraint (`SYS_CHK_CONSTRS.chktext`).


    public
        string
    CHECK_TEXT
    = 'checkText'

Column name participating in the constraint (`SYS_KEYCOL_USAGE.col` / `SYS_CHKCOL_USAGE.col`).


    public
        string
    COLUMN
    = 'column'

Name of the constraint (`constrname`).


    public
        string
    CONSTRAINT_NAME
    = 'constraintName'

Owner (SQL schema) of the constraint (`constrowner`).


    public
        string
    CONSTRAINT_OWNER
    = 'constraintOwner'

Constraint type (`constrtype`): `P` (primary key), `U` (unique), `F` (foreign key) or `C` (check).


    public
        string
    CONSTRAINT_TYPE
    = 'constraintType'

Deferrability mode of the constraint (`deferrability`).


    public
        string
    DEFERRABILITY
    = 'deferrability'

`DELETE` referential action (`delete_rule`): `C` (cascade), `N` (set null), `D` (set default), `R` (restrict) or `A` (no action).


    public
        string
    DELETE_RULE
    = 'deleteRule'

Position of the column within a multi-column key (`keyseq`).


    public
        string
    KEY_SEQUENCE
    = 'keySequence'

`MATCH` mode of a referential constraint (`match_type`).


    public
        string
    MATCH_TYPE
    = 'matchType'

Identifier of the unique/primary key constraint referenced by a foreign key (`uniquename`).


    public
        string
    UNIQUE_NAME
    = 'uniqueName'

Owner (SQL schema) of the referenced unique/primary key constraint (`uniqueowner`).


    public
        string
    UNIQUE_OWNER
    = 'uniqueOwner'

`UPDATE` referential action (`update_rule`): `C` (cascade), `N` (set null), `D` (set default), `R` (restrict) or `A` (no action).


    public
        string
    UPDATE_RULE
    = 'updateRule'