Working with DDL definitions
This feature is available with the Database Tools and SQL plugin installed on the Settings/Preferences | Plugins page, tab Marketplace, as described in Installing plugins from JetBrains repository.
Please note that it is a paid plugin.
Edit the DDL definition of a database object
In the Database tool window (), , click a database object.
Click the Source Editor button (
) on the toolbar. Alternatively, press Ctrl+B.
Save generated DDL in SQL files
In the Database tool window (), right-click a database object and select .
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.
tip
SQL files are generated by a groovy script. To change the script, click the Settings icon (
) and select Edit.
Thanks for your feedback!