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.

StepsTo export the syntax of an existing table to a log:

  1. Select the table in the painter workspace.

  2. Select Export Syntax from the Object menu or the pop-up menu.

    If you selected a view, PocketBuilder immediately exports the syntax to the log.

  3. Specify a data source in the Data Sources dialog box.

  4. Supply any information you are prompted for.

    PocketBuilder exports the syntax to the log. Extended attribute information (such as validation rules used) for the selected table is also exported.

    For more information about the log, see “Logging your work”.