IntelliJ IDEA 11.1 Web Help

Some features described here are available in Ultimate edition only.
To generate a data structure definition (DDL) file
  1. In the Data Sources tool window, select the desired data source, table, or column, and do one of the following:
    • Choose Generate and Copy DDL on the context menu.
    • Press the Ctrl+Shift+CCommand Shift C keyboard shortcut.
    • Click the Generate and Copy DDL toolbar button icon_sqlOpenInEditor.

    As a result, IntelliJ IDEA 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

IntelliJ IDEA 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.

11.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 to open the context menu, select Change <current option> SQL dialect to, and then select 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: