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:
- SQL Server
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).
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
The SQL server should be running. You can create a special command using the external tools
configuration facility, as described in the section Using
In this section: