Create Table: Column Referential Constraints panel

You use the Create Table: Column Referential Constraints panel to specify information to define one or more column referential constraints for the table.

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

Parent panels

Child panels

None.

Related tasks