IntelliJ IDEA 12.1.0 Web Help

8.0+
Some features described here are available in Ultimate edition only.

With IntelliJ IDEA, you can query and modify configured data sources from the dedicated Database Console tool window using one of the supported languages:

You can either enter all the necessary commands in the Input pane of the console or prepare a file that contains commands in the desired language. In both cases, IntelliJ IDEA provides code specific completion, syntax and error highlighting, and completion of the data source, table and column names.

IntelliJ IDEA also supports operations with database binary large objects (BLOBs).

Tip

The Input pane opens as a new editor tab as soon as the Database console is invoked.

Retrieved records are shown in the Result pane, where you can view, analyze, and update them.

IntelliJ IDEA opens connections to databases when necessary without any steps from your side and displays them below corresponding data source nodes in the Database tool window.

Tip

The SQL server should be running. You can create a special command using the external tools configuration facility, as described in the section Using Third-Party Tools.

In this section:

To launch the Database console
  1. Open the Database tool window.
  2. Select the desired data source.

    sqlSelectDataSource.png

  3. Right-click the tool window (any node or the background), and choose runJdbcConsole.png Open Database Console, or press Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+F9Shift+Alt+F6 or Shift+F6Ctrl+Shift+F10Control Shift F10Control Shift F10Control Shift R. The Database console tool window for accessing the selected data source opens.
    • The Result and Output panes open as usual, in the bottom area of the screen.
    • The Input pane opens as a separate editor tab.

See Also

Procedures:

Language and Framework-Specific Guidelines:

Reference:

Web Resources: