You can export the syntax for a table to the log. This feature is useful when you want to create a backup definition of the table before you alter it or when you want to create the same table in another DBMS.
To export to another DBMS, you must have the PowerBuilder interface for that DBMS.
To export the syntax of an existing table to a
log:
Select the table in the Objects or Object Layout view.
Select Export Syntax from the Object menu or the pop-up menu.
If you selected a table and have more than one DBMS interface installed, the DBMS dialog box displays. If you selected a view, PowerBuilder immediately exports the syntax to the log.
Select the DBMS to which you want to export the syntax.
If you selected ODBC, specify a data source in the Data Sources dialog box.
Supply any information you are prompted for.
PowerBuilder exports the syntax to the log. Extended attribute information (such as validation rules used) for the selected table is also exported. The syntax is in the format required by the DBMS you selected.
For more information about the log, see “Logging your work”.
