We've recently announced the opening of the EAP for IntelliJ IDEA 2017.3, and we have already even looked at some interesting EAP features. However, we didn't cover changes in the database tools yet. So let's explore the major changes in this area.
Selecting Schema When Running a SQL File
IntelliJ IDEA 2017.3 now prompts you to choose database/schema along with a data source when you try to run an SQL file from the tool window:
Jumping to Console From Data Source
For easier navigation, the context menu on a data source in the tool window was upgraded. Choose Jump to Console and you'll now have a handy menu that allows you to quickly switch between your consoles.
Right-Side Alignment for Numeric Data
For better readability, the IDE aligns the data in the table editor for numerical columns with the right side:
XQuery and XPath Coding Assistance for Microsoft SQL Server
Last but not least, the / support for Microsoft SQL Server is now provided through the Injected Languages feature:
Since the feature has been asked for by some of our users, we backported it to IntelliJ IDEA 2017.2, as well.