Working with DDL definitions

In the Database tool window (View | Tool Windows | Database), , click a database object.

Click the Source Editor button () on the toolbar. Alternatively, press ⌃ B.

In the Database tool window (View | Tool Windows | Database), right-click a database object and select SQL Scripts | SQL Generator ⌃ ⌥ G.

In the SQL Generator tool window, click the File Output Options icon ().

From the Layout list, select a method that you want to use:

• File per object: generates a set of SQL files.

• File per object with order: generates a numbered set of SQL files.