Working with DDL definitions

Last modified: 15 June 2021

Edit the DDL definition of a database object

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

  2. Click the Source Editor button (the Source Editor button) on the toolbar. Alternatively, press Ctrl+B.

Edit the DDL definition of a database object

Save generated DDL in SQL files

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

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

  3. 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.

    Generate DDL for database objects

tip

SQL files are generated by a groovy script. To change the script, click the Settings icon (The Settings icon) and select Edit.

Go from a reference to its DDL definition

  1. In the Setting/Preferences dialog Ctrl+Alt+S, navigate to Database | General.

  2. In the Navigation pane, clear the Prefer database view over DDL editor checkbox.

Open a definition in the DDL editor