You can create a new table that is similar to an existing table very quickly by using the Save Table As menu option.
To create a new table from an existing table:
Open the existing table in the Columns view by dragging and dropping it or selecting Alter Table from the pop-up menu.
Right-click in the Columns view and select Save Table As from the pop-up menu.
The Create New Table dialog box displays.
Enter a name for the new table and then the owner’s name, and click OK.
The new table appears in the Object Layout view and the Columns view.
Make whatever changes you want to the table definition.
Save the table.
Make changes to the table’s properties in the Object Details view.
For more information about modifying table properties, see “Specifying table and column properties”.
