SQL Executor

The SQL Executor tool allows you to execute SQL scripts and data queries in a fast and easy way. To open the SQL Executor select the Tools | SQL Executor main menu item.

The main tab of the SQL Executor is SQL, which allows you to type in the SQL text for execution.

The syntax highlight makes the edited SQL text more convenient for viewing and editing. The popup menu of the editor provides standard functions for working with the text as well as some advanced functions.

The Load SQL/Save SQL to File functions allow you to load SQL text from file on disc or save the edited text to file. The Save SQL to Profile function allows you to save the current SQL as a profile query. The Insert Table function opens a dialog window for selecting a table to insert into the query text. The selected table is inserted in the following format: SELECT [COLUMNS...] FROM <TABLE_NAME>. The Insert Query function opens a dialog window for selecting one of the already existing profile queries to insert its full text into the query. This can be useful, e.g. for creating queries with sub-selects.

When you are done with the SQL text, you can execute it using the Execute button on the toolbar, or by pressing the F9 key.

The scripts and queries you execute can contain as lot statements as required, separated by semicolons. If a script contains SELECT or SHOW statements, the results of these appear in separate grids on the Result tab.

The popup menu of each grid provides functions for filtering and exporting data.

The bottom area shows the result of executing each statement - the number of rows fetched or effected in case of success, or the error message.