Working with the Database Console
The database console lets you compose and execute SQL statements for any database defined in IntelliJ IDEA as a data source. It also lets you analyze and modify the retrieved data.
The following standardized and DBMS vendor-specific SQL dialects are supported: DB2, Derby, H2, HSQLDB, MySQL, Oracle, Oracle SQL*Plus, PostgreSQL, SQL Server, SQL92, SQLite, and Sybase .
General console usage instructions are on this page:
More specific subjects are discussed in:
See also, Database Console.
Opening the database console
- Open the Database tool window.
- Select the DB data source for which you want to open the console or any node within that data source.
Do one of the following:
- Click on the title bar.
- Click on the toolbar (if the toolbar is not currently hidden).
- Select Console from the context menu.
- Press Ctrl+Shift+F10.
Viewing and modifying the console settings
- To access these settings, click on the toolbar of the input pane or on the toolbar of the Database Console tool window (in the lower part of the workspace, if this tool window is currently shown).
Changing the SQL dialect
- Right-click in the editing area of the input pane to open the context menu.
Point to Change '<current_dialect_name>' dialect to and
select the necessary dialect.
In addition to particular dialects, also the following option is available:
- <Generic>. Basic SQL92-based support is provided including completion and highlighting for SQL keywords, and table and column names. Syntax error highlighting is not available. So all the statements in the input pane are always shown as syntactically correct.