SQL Editor for all Databases

DatabaseSpy supports SQL editing for all major databases, at a fraction of the cost of single-database solutions.

Firebird 2.5, 3

IBM DB2 for iSeries® v6.1, 7.1

IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5

Informix® 11.70, 12.10

MariaDB 10, 10.3

Microsoft Access™ 2003, 2007, 2010, 2013

Microsoft® Azure SQL

Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016, 2017

MySQL® 5, 5.1, 5.5, 5.6, 5.7, 8

Oracle® 9i, 10g, 11g, 12c

PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10

Progress OpenEdge 11.6

SQLite 3.x

Sybase® ASE 15, 16

Teradata 16

Windows in the SQL Editor

The DatabaseSpy SQL editor makes it easy to create, display, edit, and execute the SQL statements that are required for your database work. You can save SQL scripts that you have created in the SQL Editor and add them to your project. In addition, you can also open existing SQL files and display them in the SQL Editor.

The 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.

DatabaseSpy 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.

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.