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.
Figure 16-4: SQL syntax for pending changes to a table
To view pending SQL syntax changes:
Right-click the table definition in the Columns view and select Pending Syntax from the pop-up menu.
PocketBuilder displays in SQL syntax the pending changes to the table definition.
The SQL statements execute only when you save the table definition or reset the view and then tell PocketBuilder to save 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 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.
To print pending table changes:
While viewing the pending SQL syntax, click the Print button or select Print from the File menu.
To display columns in the Columns view:
Select Object>Pending Syntax from the menu bar.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
