Manage Your Database Schema in IntelliJ IDEA 12
As you know, IntelliJ IDEA provides built-in database tools with support for many SQL dialects, such as Oracle, PostgreSQL, MySQL, Microsoft SQL Server and others.
A while ago we shared this video with a quick overview of how to set up a connection to a database, use smart completion (even for SQL queries within Java), on-the-fly code analysis, navigation (between queries and database), search (for tables and fields), and more cool features.
Now, please enjoy a new video with even more exciting features available in IntelliJ IDEA 12 for working with databases:
Manage Your Database Schema from the IDE
Now you are able to define tables, columns, indexes and foreign keys simply from the Database tool window via the shortcut (Ctrl+N) or the context menu.
Create New Table
The new table wizard brings code completion and SQL preview with support for all listed dialects, so you can define a new table for any database in seconds.
If you modify a column (Cmd+F6), the IDE will automatically show you how your changes affect the project and will apply the appropriate changes to the code.
The table editor and query console support manual transaction control, so you can commit more than one change at once or roll it back safely whenever you want.
Data from the table editor or query results may be exported to a file or clipboard in the following formats: CSV, TSV, HTML, SQL Insert/Update statements.
If you open a CSV file in the editor, the IDE will offer you to edit data in a table.
The Database tool window also provides the Quick Documentation action via Ctrl+J for any selected element from the database. The popup window shows the SQL definition for selected item and the first 10 rows (for tables and views).
As databases are part of most projects today, it was about time for us to help developers work with them more productively. Find these and many other features for database development in the latest release of IntelliJ IDEA.
Develop with Pleasure!
Subscribe to Blog updates
Build a Spring Boot App with AI Assistant
In this article, we’ll be building a small Java Spring Boot web application in IntelliJ IDEA with the help of JetBrains AI Assistant. If you’d like to follow along with this tutorial, you’ll need IntelliJ IDEA Ultimate, as well as an active subscription to AI Assistant or the free seven-day trial…
Top 10 UI Updates in IntelliJ IDEA for 2023
Hey there, fellow developers! Today, we want to share the most significant UI updates from 2023 that have transformed how IntelliJ IDEA looks and functions. New UI Of course, the highlight of our recent updates was the launch of our new, clean, and modern UI. This was first announced at the en…
The What, Why, and How of JPA Buddy in IntelliJ IDEA
Master JPA entity management with JPA Buddy in IntelliJ IDEA! Our latest article shows you how to simplify your workflow and reduce boilerplate code.
The Best of IntelliJ IDEA’s HTTP Client
In today's fast-paced tech world, easy and efficient management of web services and APIs is crucial. That's where IntelliJ IDEA's HTTP Client steps in, turning complex HTTP requests into a walk in the park. The HTTP Client is a feature-rich, text-based tool in IntelliJ IDEA Ultimate. It seamlessl…