The SQL-query tool
When working with the source databases, the database explorer offers a useful SQL query tool. This tool allows to investigate the content of their tables or to perform free SQL statements on them.
There are two ways to open the query tool: You can open the context menu on a database in the database explorer or you can open the context menu on a single table.
The context menu for a database contains an item "Execute SQL query...". This will open an empty query window without any SQL query.
The context menu for a table contains an item "Show table-data". This also opens the query toolbar, but with a statement "SELECT * FROM <table>" which will instantly be executed. This statement will show the content of the table with all of its columns.
Elements of the query tool
The query tool contains three elements: The large text box where you can enter and edit the SQL statement, the result window below the text box and a toolbar.
The result window will show the result or, if any error occurred while executing the query, error messages.
The toolbar
The query tool contains a small toolbar at the right border. It offers two buttons:
This button executes the SQL statement or, if a part of the statement is selected, the current selection of the statement. By using selections you can hold multiple statements in the editor window and execute a single statement by selecting it.
Instead of using this button you can also press ENTER while holding the CTRL key.
Any result displayed in the result window below the statement is limited to the first 1000 rows by default. You can change this limit with this button.
