Create Table panel

You use the Create Table panel to create a new table.

Panel and field definitions

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

 New Table:
    Owner . . . . . . .                   + (optional)
    Name  . . . . . . . TABLE1                                              +
    Database  . . . . .                     (optional)
    Table Space . . . .                     (optional)

 Model Table/View:  (optional)
    Owner . . . . . . .                   +
    Name  . . . . . . .                                                     +
    Usage:
       1  1. Generate LIKE clause
          2. Load table information

 Table Creation:
    Creation Options              (Use option 1 before options 2, 4-9)
    1  1. Columns                 (normally required, invalid with model LIKE)
       2. Nulls/default values    (optional)
       3. Table options           (editproc,validproc,more; optional)
       4. Unique Constraints      (primary/unique keys; optional)
       5. Referential Constraints (foreign keys; optional)
       6. Check constraints       (optional)
       7. Procedure exits         (optional)
       8. Generate values         (optional)
       9. Create the table
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Owner (New Table)

The name of the owner of the new table.

Name (New Table)

The name of the new table.

Database

The name of the database in which the new table is to be created.

Table Space

The name of the table space in which the new table is to be created.

Owner (Model Table/View)

The name of the owner of the model table.

Name (Model Table/View)

The name of the model table.

Creation Options

Specify the number of the creation option you want to use:

1. Columns: To specify information to define the columns for a table to be created. Displays the Create Table: Columns panel.
2. Nulls/default values: To specify information to define the null attributes and default values for the columns of the table. Displays the Create Table: Nulls and Default Values panel.
3. Table options: To specify information to define options for the table you are creating. Displays the Create Table: Options panel.
4. Unique Constraints: To specify information to define a primary key and up to three additional unique keys for the table you are creating. Displays the Create Table: Unique Constraints panel.
5. Referential Constraints: To specify information to define one or more column referential constraints for the table. Displays the Create Table: Column Referential Constraints panel.
6. Check Constraints: To specify information to define column check constraints for the table. Displays either the Create Table: Column Check Constraints panel or the Create Table: Table Check Constraints panel.
7. Procedure exits: To specify information to define procedure exits for the table you are creating. Displays the Create Table: Procedure Exits panel.
8. Generate values: To specify information to define generated values for identity or ROWID columns in the table. Displays the Create Table: Generate Values panel.
9. Create the table: When you have finished specifying details for the table to be created, select this creation option to create the table.

Parent panels

Child panels

This table has two columns, except for the final row, "Notes®:", which spans both columns.
To display this panel…	Use/do this
Create Table: Columns panel	Creation option 1
Create Table: Nulls and Default Values panel	Creation option 2
Create Table: Options panel	Creation option 3
Create Table: Unique Constraints panel	Creation option 4
Create Table: Column Referential Constraints panel	Creation option 5 ¹
Create Table: Column Check Constraints panel	Creation option 6
Create Table: Procedure Exits panel	Creation option 7
Create Table: Generate Values panel	Creation option 8
Create Table: Model Load panel	See note below ²
Create Table: Columns panel	See note below ¹
Notes: When you select Table Creation option 5 (Referential Constraints) on the main Create Table panel, FM/Db2 displays either the Column Referential Constraints panel (Create Table: Column Referential Constraints panel) or the Table Referential Constraints panel (Create Table: Table Referential Constraint panel). To change from one panel to the other, press the F5 function key. The Create Table Model Load panel is displayed when you: Initially specify, or subsequently change, the Model Table/View details, Select Usage option 2 (Load table information), and Press Enter.

Related tasks

Creating a table