Exporting table syntax
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.