Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 71
Deleting orphaned
table information
If you drop a table outside DataWindow Designer, information remains in the
system tables about the table, including extended attributes for the columns.
❖ To delete orphaned table information from the extended attribute system
tables:
• Select Design>Synch Extended Attributes from the menu bar and click
Yes.
If you try to delete orphaned table information and there is none, a
message tells you that synchronization is not necessary.
Viewing pending SQL changes
As you create or alter a table definition, you can view the pending SQL syntax
changes that will be made when you save the table definition.
❖ To view pending SQL syntax changes:
• Right-click the table definition in the Columns view and select Pending
Syntax from the pop-up menu.
DataWindow Designer displays the pending changes to the table definition
in SQL syntax:
The SQL statements execute only when you save the table definition or
reset the view and then tell DataWindow Designer to save changes.
Copying, saving, and
printing pending SQL
changes
When you are viewing pending SQL changes, you can:
• Copy pending changes to the clipboard
• Save pending changes to a file
• Print pending changes
To copy, save, or print only part of the SQL syntax
Select the part of the SQL syntax you want before you copy, save, or print.