How to run SQL script?
Create or open a .sql file, Ctrl+F10 to run the script or the selected portion if there is any
How to invoke SQL code completion?
Create or open a .sql file, Ctrl+Space to popup the completing list or hit "dot" after a table, catalog, schema
or correlation name
What are templates?
Users can use Velocity (Apache project) templates to extend dbhelper plugin. Some examples are in the plugin zip
file. You can get the zip file from http://plugins.intellij.net/plugin/?id=1120.
If you got the zip file, the sample files should be under %IDEA%\plugins\DBHelper\templates.
The detailed information about managing and writing the templates is in the help html files, which is located at:
%IDEA%\plugins\DBHelper\help
How to setup templates?
Go to "Settings" tab in DBHelper tool window and specify the folder name in the templateFileFolder property
What can I do with templates?
DBHelper exposes the query resulset, tables, table, stored procedure as the template parameter. Users can write
Velocity templates to build their own output, such as copy the result as an XML document or generate jdbc calls to
retrieve the resultset or query a selected table.
How can I save my query to the SavedQueries tab?
In a SQL file editor, Ctrl+F10 to run the script or the selected portion. If the script generates a resultset,
the user will see the resultset in the dboutput tool window. Click the save icon to save the script into the SavedQueries
tab.
Is there a way to print the database diagram?
Yes. Select the objects that you want to print and right-click at an empty area on the diagram (Not on a shape),
Select the "Copy diagrams as Image" to copy it as an image and paste it into any editors that support printing
graphics.
How can I tell the code completer window to refresh after I create a table?
Right-click the tables or procedures node in DB Tree tab and select refresh folder.