Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 63
5 Click the Save button or select Save from the File or pop-up menu, then
enter a name for the table in the Create New Table dialog box.
DataWindow Designer submits the pending SQL syntax statements it
generated to the DBMS, and the table is created. The new table is
displayed in the Object Layout view.
About saving the table
If you make changes after you save the table and before you close it, you
see the pending changes when you select Pending SQL again. When you
click Save again, DataWindow Designer submits a
DROP TABLE
statement to the DBMS, recreates the table, and applies all changes that are
pending. Clicking Save many times can be time consuming when you are
working with large tables, so you might want to save only when you have
finished.
6 Specify extended attributes for the columns.
For what to enter in each field, see “Specifying column extended
attributes” on page 66.
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:
1 Open the existing table in the Columns view by dragging and dropping it
or selecting Alter Table from the pop-up menu.
2 Right-click in the Columns view and select Save Table As from the pop-up
menu.
3 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.
4 Make whatever changes you want to the table definition.
5 Save the table.
6 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” on page 64.