Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 69
Database painter is DBMS aware
The Database painter grays out or notifies you about actions that your DBMS
prohibits.
For complete information about what you can and cannot do when you modify
a table in your DBMS, see your DBMS documentation.
❖ To alter a table:
1 Highlight the table and select Alter Table from the pop-up menu.
Opening multiple instances of tables
You can open another instance of a table by selecting Columns from the
View menu. Doing this is helpful when you want to use the Database
painter's cut, copy, and paste features to cut or copy and paste between
tables.
The table definition displays in the Columns view (this screen shows the
Employee table).
2 Make the changes you want in the Columns view or in the Object Details
view.
3 Select Save Table or Save Changes.
DataWindow Designer submits the pending SQL syntax statements it
generated to the DBMS, and the table is modified.