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.
-
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.
