Generally, the best method for displaying generated SQL
depends on the number of objects you want to review and the associations
among them.
Note: When you browse generated SQL, you cannot edit it.
To edit the generated SQL, you must select Review SQL from
the Options menu and select Create
Object from the shortcut menu or select Create
All Selected Objects from the Tools menu.
- To review the SQL for a single object,
right-click the name and select Browse Object SQL from
the shortcut menu. You are not required to select the Select check
box.
- To review the SQL for a table and
the subordinate objects, right-click the table name and select Browse
All Selected Table Objects. You are not required to select
the Select check box for the table, but must
select it for any subordinate objects to be created.
- To browse the SQL for several selected
objects that are listed on the tab, select the appropriate Select check
boxes before you select Browse All Selected Objects from
the Tools menu.
- To browse the SQL for all objects
that are listed on the tab, use the Select All Objects shortcut menu
command before you select Browse All Selected Objects from
the Tools menu.
Note: In Optim 11.3, SQL generation is not supported for PostgreSQL.