Creating Tables from Existing Tables

If you want to create a table that is similar to a table in your IBM^® database, you can base the new table on the existing table definition.

To create a table from an existing table:

In the Server Explorer under your IBM data connection, expand the Tables folder.
Right-click the table that you want to use as the basis for the new table, and then select Clone Definition on the shortcut menu.
The IBM Table Designer opens, with the information for the selected table displayed in the fields of the designer. The value in the Table name field contains an incremental numeric suffix.
Change, add, or delete the information in the views of the designer to define the new table.
For detailed information about the fields in the designer views, see IBM Table Designer.
Save the table definition.
The table is created and added to your database.
Close the designer.