SQL Query Tool

Advanced users, which are familiar with SQL, will find Database Tour useful to create and execute database queries.

Syntax Highlighting

The SQL editors of Database Tour support syntax highlighting for SQL code. They recognize standard SQL keywords and even specific keywords for some database types. You can customize the highlighting in environment options.

SQL syntax highlighting

Multiple SQL Windows

Once you opened a database, you can create as many SQL windows as you want (or your operating memory allows). They appear as tabs. This is especially useful when comparing the text from different SQL files or stored procedures, copying text etc.

When you close the database and exit the application, all unclosed SQL windows are kept in the application workspace file and restored when you open the database next time.

Multiple SQL windows

Simultaneous Query Execution

If your database connection allows creating multiple sessions, each SQL window will hold a separate db session. It means that you can execute the queries from different SQL windows asynchronously, without needing to wait when a query from another SQL window is finished.

Each SQL tab shows markers reflecting the execution status of its query: red marker is shown for still executing query, and the green one reports the finished query; a special mark indicates a query finished with error.

In multi-session environment, to save resources of your database, each new database session is created at the moment when you first try to execute the query from active window.

Asynchronous query execution

Queries with Parameters

Database Tour supports parameterized SQL queries. When you execute such a query, the software will ask you to specify the value for each parameter.

Parameterized SQL query

Running Multi-Statement SQL Scripts

Your SQL editor can hold multiple SQL commands. You can execute them either separately (by selecting the text of the needed command) or all together. In the latter case, you can view the statistics of each executed command in the script. Make sure to properly separate the commands; for most database types, semicolon is used to separate the SQL statements.

Executing SQL script

Clickable Table Names

SQL editor recognizes table names and some other db objects in the SQL code. When you slightly move the mouse over them holding Ctrl down, they become clickable. When you click the table name holding Ctrl down, this table opens in a separate tab.

Clickable table names