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 browsing 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 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 listed
on the tab, select the appropriate Select check
boxes before selecting Browse All Selected Objects from
the Tools menu.
- To browse the SQL for all objects listed on the
tab, use the Select All Objects shortcut
menu command before selecting Browse All Selected Objects from
the Tools menu.