You can very quickly create a new table that is similar to an existing table 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 by 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 Objects 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”.
