Create Table: Column Referential Constraints panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)    Create Table: Column Referential Constraints  Row 1 to 1 of 1

    Owner . . . . . . .                                                        +
    Name  . . . . . . . TAB1                                                   +
    Database  . . . . .
    Table Space . . . .

                    Constrnt <--------------- Parent Table ---------------> ON
 Column Name      + Name   + Owner  + Name             + Column           + DLT
 COL1                                                                        
 ******************************* Bottom of data ********************************








 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F5=Tabcons   F7=Backward
  F8=Forward   F9=Swap     F10=Left     F11=Right    F12=Cancel

Column Name

The foreign key. This is the column in the table being created that is to be related to an equivalent column (the parent key) in the parent table.

Constrnt Name

Optionally use this field to specify the name of the constraint.

Owner

Optionally use this field to qualify the name of the parent table.

Name

The name of the table containing the parent key. This field is mandatory.

Column

The parent key. Specify the name of the column in the parent table to which you want the foreign key (in Column Name) related. The parent key must be a primary or unique key on the parent table. If you leave the Parent Table Column field blank, the foreign key is related to the primary key of the parent table.

ON DLT

Determines the type of ON DELETE clause, if any, that FM/Db2 generates in the CREATE TABLE statement. Valid values are:

(blank)

No ON DELETE clause generated

R

ON DELETE RESTRICT

N

ON DELETE NO ACTION

C

ON DELETE CASCADE

S

ON DELETE SET NULL