Query Editor

Top  Previous  Next

The query editor is a extremely powerful tool for editing and executing all types of SQL.

It handles large result sets with ease because it only loads enough records  to fill the grid area,

as you scroll through the result set it loads more.

 

Notice messages are properly received from the server and displayed in the messages tab.

 

Code completion may be invoked in the editor by typing the name of a schema and a . (period) or by hitting CTRL+SPACE

 

Long running queries may also be canceled (user running the query must be a super user and be using a 8.x server) and run

in the context of a thread. While a long running query is executing you may open another query editor and work on something else.

A running queries tab will change color and display a timer to indicate the query is running.

 

Please see here for information on how to run a query.