Alter Table panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                    Alter Table

 Table Identification:
    Table owner  . . . . . KPS8810_LONG      +
    Table name . . . . . . VACT                                                +

 Processing Options:
    Select type of ALTER
        1. AUDIT                       7.  DROP FOREIGN KEY constraint
        2. ADD column                  8.  DATA CAPTURE
        3. VALIDPROC                   9.  ADD CHECK constraint
        4. ADD PRIMARY KEY             10. DROP CHECK constraint
        5. ADD FOREIGN KEY constraint  11. ADD RESTRICT ON DROP
        6. DROP PRIMARY KEY            12. DROP RESTRICT ON DROP





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

Parent panels

Child panels

To display this panel… Use/do this
Alter Table - AUDIT panel Processing option 1
Alter Table - ADD Column panel Processing option 2
Alter Table - VALIDPROC panel Processing option 3
Alter Table - ADD PRIMARY KEY panel Processing option 4
Alter Table - ADD FOREIGN KEY Constraint panel Processing option 5
Alter Table - DROP PRIMARY KEY panel Processing option 6
Alter Table - DROP FOREIGN KEY Constraint panel Processing option 7
Alter Table - DATA CAPTURE panel Processing option 8
Alter Table - ADD CHECK Constraint panel Processing option 9
Alter Table - DROP CHECK Constraint panel Processing option 10
Alter Table - RESTRICT ON DROP panel Processing option 11 or 12

Related tasks