PyCharm 2.7 Web Help

To generate a data structure definition (DDL) file
  1. In the Database tool window, select the desired data source, table, or column, and do one of the following:
    • Right-click selection, and choose icon_generateDDL Generate and Copy DDL.
    • Press the Ctrl+Shift+CCommand Shift C keyboard shortcut.

    As a result, PyCharm will place the generated statements onto the clipboard.

  2. In the Project tool window, create a file with the desired name and the extension .ddl.
  3. Open new file in the editor and paste the generated statements from the clipboard.

Warning

PyCharm parses the specified file according to the SQL dialect assigned to it or its parent. To have the data structure created successfully, this dialect should support DDL statements. SQL dialect settings are specified in the SQL Dialects page of the Settings dialog box.

2.0+↓

Note that you can change the SQL dialect for any SQL or DDL file open in the editor by selecting the corresponding context menu command.

To change the SQL dialect for an SQL or DDL file
  1. Open the file of interest in the editor.
  2. Right-click somewhere in the editor, point to Change <current option> SQL dialect to, and then click more.
  3. In the SQL Dialects dialog that opens, click the corresponding SQL Dialect cell, select the desired dialect from the list, and click OK.

See Also

Concepts:

Procedures:

Reference:

Web Resources: