WebStorm 2024.2 Help

Working with DDL definitions

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.

  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
Last modified: 11 October 2024