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.