Query execution
File | Settings | Tools | Database | Query Execution for Windows and Linux
IntelliJ IDEA | Settings | Tools | Database | Query Execution for macOS
This topic describes the available settings for a query execution. For more information about running queries and viewing the results in IntelliJ IDEA, refer to the following topics:
For more information about running queries, refer to the Run queries topic.
Learn how to view the query result in the Query results topic.
Item | Description |
---|---|
When caret inside statement execute | If the caret is inside a statement, perform the following actions:
|
When caret outside statement execute | If the caret is outside a statement (for example, on a blank line or within a comment), perform one of the following actions:
|
For selection execute | If the code is selected (highlighted), perform one of the following options:
|
Open results in new tab | You can select to view query results on individual tabs, or on one and the same tab. For the single tab, the tab is updated for each query.
|
Split a script for execution in Generic and ANSI SQL dialects | Set the query parsing for unsupported databases that use SQL:2016 or Generic dialects. The Generic dialect differs from SQL:2016 in error highlighting. In the Generic dialect, all found errors are not highlighted.
|
Review parameters before execution | When you run a statement with parameters, IntelliJ IDEA saves parameter values in memory. Select this checkbox and next time you execute the statement, IntelliJ IDEA will show you the last used parameter values. You can change them before running the statement. Clear this checkbox and IntelliJ IDEA will execute the statement immediately without showing you the parameter values. |
Show warning before running potentially unsafe queries | Select to display warnings for potentially unsafe queries. If you forgot to put the |
Thanks for your feedback!