DatabaseSpy SQL Editor

Multi-database SQL editor in Altova DatabaseSpy

SQL Editor Features:

  • Automatically adjusts syntax for different database types
  • Pop-up auto-completion window
  • Multiple tabbed or stacked results
  • Asynchronous query execution
  • Selective partial query execution
  • Copy and paste between multiple open windows
  • Define regions and name targeted results windows
  • Auto-generate a variety of common queries
  • Save and reload common queries in project files

Download Trial

Supported Databases:

  • Firebird 2.5
  • IBM DB2 for iSeries® v6.1, 7.1
  • IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
  • Informix® 11.70
  • Microsoft Access™ 2003, 2007, 2010, 2013
  • Microsoft® Azure SQL
  • Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
  • MySQL® 5, 5.1, 5.5, 5.6
  • Oracle® 9i, 10g, 11g, 12c
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
  • Progress OpenEdge 11.6
  • SQLite 3.x
  • Sybase® ASE 15

SQL Editor Windows

The DatabaseSpy® 2017 SQL Editor is divided into a SQL statement window and one or more tabbed or stacked Result windows, with a convenient Execute button in the SQL Editor toolbar to let you immediately execute your SQL statements and view the output.

The SQL statement window applies color coding to each SQL statement with unique identification for SQL statements, parameters, operators, and comments to help you quickly and easily review and analyze an individual SQL query or a complex series of SQL commands. The DatabaseSpy Options dialog even lets you set your own preferences for the fonts, sizes, and colors applied.

A message tab window associated with the SQL query results provides information about each statement executed, including identification of any syntax errors.

The SQL Editor window also supports multiple open SQL queries and you can copy and paste between them. Each SQL Editor window has a corresponding Properties helper window with information and parameters that can be edited. For instance, you might want to devise, refine, and execute a SQL query against a test database before committing changes to live data. Editing the database connection in the Properties window lets you easily redirect your query to the live database once it has been perfected.

DatabaseSpy supports asynchronous query execution, allowing multiple SQL queries to be processed in different windows at the same time, either queries to different servers or even multiple queries against the same server.

Efficient SQL Editing

As you construct a new SQL query from scratch, the auto-completion feature prompts with options that match the correct syntax at each keyword of the statement. Context-Sensitive Suggestion allows you to view only items that are valid at your current cursor position within the SQL statement, and you can modify the suggestions to create a customized list.

The DatabaseSpy SQL Editor lets you organize long and complex groups of SQL statements by separating them into regions that can be individually collapsed or expanded. Regions can even be nested, and a handy button in the SQL Editor toolbar lets you hide or expand all regions with a single click.

Navigation buttons in the SQL Editor toolbar let you step through the query statement-by-statement, and the unlimited undo/redo toolbar buttons let you freely experiment, yet recover an earlier version if you want.

SQL auto-completion in Altova DatabaseSpy

Results Window

DatabaseSpy Result windows may be tabbed or stacked to show multiple results simultaneously. Each Result window offers options to further refine output after you have executed SQL statements. You can drag column heading separators to adjust column widths, or click on any column heading to sort results based on that column.

When you select a column of number data, the minimum, maximum, and sum of all values in the column is automatically displayed. The Data Inspector button lets you open a new window to example any long text view.

You can select any range of cells within the results and copy for export either with or without column headers. Or, click the chart tool in the Results toolbar to generate a customized chart of SQL query results.

SQL Formatting

DatabaseSpy includes options to let you customize the format of SQL statements based on the database SQL dialect and your own preferences. Default editable SQL formatting configurations are provided for each supported database. You can even create a new configuration to easily apply different formatting when you switch databases.