RubyMine
 
2022.3
Shortcuts: Windows
Get RubyMine
You are viewing the documentation for an earlier version of RubyMine.
  1. Database tools and SQL
  2. Source code of database objects
  3. Working with DDL definitions

Working with DDL definitions

Last modified: 21 December 2022

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.