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

Working with DDL definitions

Last modified: 21 December 2022

Available only in PyCharm Professional: download to try or compare editions

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.