Create Table: Unique Constraints panel

You use the Create Table: Unique Constraints panel to specify information to define a primary key and up to three additional unique keys for the table you are creating.

Panel and field definitions

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

 Constraint Names (optional):
    Primary Key  .                                                     +
    Unique Key 1 .                                                     +
    Unique Key 2 .                                                     +
    Unique Key 3 .                                                     +

 <---- Column Order in Key ---->
 Primary Unique1 Unique2 Unique3 Column Name      + Datatype(length)           +
                                 COL1               CHAR(3)
 ******************************* Bottom of data ********************************







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

Primary: If not blank, shows the relative order of the column for the primary key.
Unique1: If not blank, shows the relative order of the column for the first unique key.
Unique2: If not blank, shows the relative order of the column for the second unique key.
Unique3: If not blank, shows the relative order of the column for the third unique key.
Column Name: The name of the column.
Datatype(length): The data type and, if applicable, the length of the column.

Parent panels

Create Table panel

Child panels

None.

Related tasks

Creating a table