Database Tools: What’s New in IntelliJ IDEA 2017.2

Andrey Cheptsov

If you’re following our recent news, you already know that last week we released the new massive IntelliJ IDEA update, 2017.2. However, we didn’t mention its database tools much in the release announcement, so now it’s time to catch up on that, because there’s plenty of new features in that area.

Amazon Redshift and Microsoft Azure

These cloud database providers are now supported out of the box with dedicated drivers and their specific SQL syntaxes.

If you’re already using any of them via the standard SQL Server or PostgreSQL drivers, make sure that you migrate to the new dedicated drivers after upgrading to 2017.2.

Connecting to multiple PostgreSQL databases

You don’t need to create separate Data Sources for each of PostgreSQL databases you’re using anymore. Just select as many databases as needed when configuring a single PostgreSQL Data Source.

Evaluate expression

This feature, with which you could already be familiar if you’ve worked with Java code,, is now available for SQL expressions, too and allows you get a preview of a table, a column, or a query.

It can be invoked either via Alt+clicking an expression or selecting it and pressing Ctrl+Alt+F8 (Cmd+Alt+F8 for macOS). In case the expression you need to evaluate isn’t in the code, press Alt+F8, and you will get a dialog where you can enter it and see what it produces.

Transaction control

Auto-commit option in the Console has been replaced with its more advanced version, called Transaction Control, which is made available not only in the Console toolbar, but as the Data Source configuration option as well, and in addition to controlling the transaction mode (automatic or manual), also defines the transaction isolation level.

When this option is set to Manual, the toolbar will display the Commit and Rollback buttons.

Table DDL

The DDL tab is removed from the Table Editor, and now if you want to see DDL, call Edit Source by clicking the its icon in the Database tool window toolbar, or via the Ctrl+B (Cmd+B for macOS).

By the way, DataGrip 2017.2 release that will include all these features is just around the corner, so stay tuned for updates!

The IntelliJ IDEA and DataGrip teams,
The Drive to Develop!

Comments below can no longer be edited.

9 Responses to Database Tools: What’s New in IntelliJ IDEA 2017.2

  1. BadUser says:

    July 28, 2017

    Please restore the DDL in the Table editor!!!

    • Maksim Sobolevskiy says:

      July 31, 2017

      Can you please describe your problem? Why do you need it? Can you tell us about your use case?

  2. Eduardo Yáñez says:

    August 9, 2017

    Where are now the data sources configurations stored?, I don’t find them within .idea directory

    • Eduardo Yáñez says:

      August 9, 2017

      Ok, just found out how to do it. I ‘moved them’ to project.

  3. Piotr says:

    January 10, 2018

    Please restore possibility to drop all tables inclusive Foreign Keys

    • Piotr says:

      January 10, 2018

      [23000][1217] Cannot delete or update a parent row: a foreign key constraint fails

      I use Ultimate 2017.3.2

      • Maksim Sobolevskiy says:

        January 12, 2018

        Do you mean DROP CASCADE? What database do you use?

      • Sylvain says:

        January 16, 2018

        Same problem here, working on a mysql db

  4. Piotr says:

    January 10, 2018

    I use Ultimate 2017.3.2

Subscribe

Subscribe for updates