We’ve added a dedicated action for opening a new console so you can assign any shortcut to it to open it even faster. If you add a row to this table, another INSERT statement will be generated: The Edit as Table action from the context menu is valid for DML, so if you have several INSERT statements, you can modify the data being inserted as a table. You can also modify existing DDL statements and generate adding indexes, keys or columns to a created table. There is a pop-up providing UI for generating statements for creating database objects, for instance, tables, functions and procedures. The Generate action, available via Alt+Ins (Cmd-N for OS X), now helps you generate and modify DDL statements. Regular Expressions are available for this search as well. It’s especially helpful if you don’t know which exact column contains the data you’re looking for.
Call up a text search in the Table Editor with Ctrl+F (Cmd-F for OS X). Sometimes it is useful to find data inside a table quickly without writing a statement.
An instant SQL preview is available so you can get a DDL statement for your changes: This action lets you add, change and remove columns, indices, and foreign keys. Now you can Modify Table (Ctrl+F6, or Cmd-F6 for OS X) from the Database tool window, or even the Editor or the Query Console. are divided into folders and can be collapsed and expanded. Now you can group objects in the Database view. Note 0xDBE is not the final name of the product and will be changed. Now, let’s take a tour of what we’ve improved since the EAP launch.įaster and more accurate schema introspectionįirst of all, we’ve reworked the way the IDE fetches meta information about database objects, and extended the JDBC-based introspection for all supported database engines to make it more native, accurate and fast.
We would very much appreciate your input and feedback. Please give it a try and share your impressions to help us polish it before release to market.Īlong with the preview we’re launching a 5-8 minute survey to get a better understanding of how you work with data. Today, we’re really excited to announce the 0xDBE 1.0 Preview, a nearly-finished version of our database IDE. Your feedback has been instrumental in shaping and improving the product. We’ve started the 0xDBE 1.0 EAP (Early Access Program) over a year ago and we appreciate how many people have participated in the program. We at JetBrains are approaching the release of our brand new IDE for developers who work with SQL and databases.
