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.
PowerBuilder 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 PowerBuilder 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.
To copy the SQL syntax to the clipboard
-
In the Pending Syntax view, click the Copy button or select Select All and then Copy from the pop-up menu.
To save SQL syntax for execution at a later time
-
In the Pending Syntax view, Select File>Save As.
The Save Syntax to File dialog box displays.
-
Navigate to the folder where you want to save SQL, name the file, and then click the Save button.
At a later time, you can import the SQL file into the Database painter and execute it.
