Table Creation options

Use the table creation options on the main Create Table panel to provide additional information to define the table you are creating.

If you are using a model table with Usage option 2, you can select any of the options 1–8 before using the Table Creation option Create the table to create the table. If you have already used the Model Load panel to provide information for the table you want to create, use the table creation options to supplement or change details you have already selected.

If you are not using a model table, you must select option 1 (Columns) and then optionally options 2–8, before using the Table Creation option Create the table to create the table.

You can revisit each of the table creation options as many times as you want to add or modify the data.

If you select one of the table creation options 1 to 8, FM/Db2 displays a panel that you use to enter information for the creation option you have selected. If you select the Table Creation option Create the table, FM/Db2 generates and issues a CREATE TABLE SQL statement.

The following pages describe the panels for each creation option.

Related references

• Create Table panel
• Create Table: Model Load panel