Create Table panel
You use the Create Table panel to create a new table.
Panel and field definitions
- 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
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 51 |
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 | 2 |
Create Table: Columns panel | 1 |
Related tasks
1 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.
2 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.