The SQL editor allows users to enter any SQL statements, highlight a query and execute it by either clicking the “Execute” toolbar button, or press “Ctrl+R”.
If the query runs too long, you can click the “Cancel” toolbar button to stop it.
The query result will be displayed in the “Query Result” view.
If all columns of a selection query are from one table and the primary key of the table is also selected, the data grid in the “Query Result” view will be editable, and you can use the options menu to insert and delete records from the table.
To achieve the best performance, a selection query will only return enough rows to fill the query result grid. You can always scroll down the grid to retrieve more result rows. For long string or CLOB columns, the query will only return the first 255 characters as a preview. The “Relationship table view” perspective has a cell editor to allow you to browse and edit the full contents of these columns.
Each SQL editor window corresponds to an opened database connection. You can use the File menu to open more connections, close a connection, open file into a SQL editor window, or save modified files.