What IntelliJ IDEA 2017.3 EAP Brings to Database Tools

Zlata Kalyuzhnaya

We’ve recently announced the opening of the EAP for IntelliJ IDEA 2017.3, and we have already even looked at some of the 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 SQL file

IntelliJ IDEA 2017.3 now prompts you to choose database/schema along with a datasource when you try to run an SQL file from the Project tool window:

Jumping to console from datasource

For easier navigation, the context menu on a datasource in the Database tool window was upgraded.  Choose Jump to Console  and you’ll now have a handy menu which 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 XQuery/XPath support for Microsoft SQL Server is now provided through the Injected Languages feature:

Place the caret to a needed code fragment and press Alt+Enter. Then choose Inject language or reference, and select XQuery or XPath:

Since the feature has been asked for by some of our users, we backported it to IntelliJ IDEA 2017.2 as well.

To give these new features a try, download the EAP build. And as usual, bug reports along with your feedback, are very welcome in our issue tracker.

The Drive to Develop!

Subscribe to IntelliJ IDEA Blog updates

Subscribe form

By submitting this form, I agree to the JetBrains Privacy Policy Notification icon

By submitting this form, I agree that JetBrains s.r.o. ("JetBrains") may use my name, email address, and location data to send me newsletters, including commercial communications, and to process my personal data for this purpose. I agree that JetBrains may process said data using third-party services for this purpose in accordance with the JetBrains Privacy Policy. I understand that I can revoke this consent at any time in my profile. In addition, an unsubscribe link is included in each email.

Submit

Thanks, we've got you!