Creating a new table from an existing table
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.