Free download Universal SQL Editor

Universal SQL Editor

1.6.9
Intellisense enabled SQL editor for DB2, Oracle, SQL server, Sybase, etc.
Free Download
User rating
5/10
20 votes
License
Shareware
OS
Windows
Developer
Version
1.6.9.1
File size
2.4 MB
Language
English
Release date
24 November 2015

Editor's review

This is a tool for creating, editing SQL queries for a range of databases.

Universal SQL Editor is a database query tool. You are able to connect to Oracle, DB2, SQL Server, Sybase and any other ODBC compliant database. You would be able to edit complex SQL with Intellisense-like features. These include auto-completion, highlight references, parameter hinting, syntax highlighting, SQL formatting and others that help in creating SQL queries easily. The query building supports grouping, filtering, searching, and can be exported to Excel spreadsheet or as a set of SQL statements. Memory footprint is small, so you do not have to worry about overloading your system. You can plug-in features by adding some DLLs designed for the same. The tool will support scripting database object on databases that support that such as Oracle, DB2, SQL Server and Sybase. When long scripts are executed, the statement that causes error will be highlighted helping debug easily.

SQL editor does SQL formatting with added features of letter case conversion, reference highlights of table, column, cursor and variables etc. Revision marking, column selection, column mode edit, code folding, full screen edits etc are useful too. Wildcard search and replace and multiple levels of undo and redo are helpful features that help a lot. The tool is also able to recognize complex SQL syntax such as, derived table, common table expression (CTE), nested query, etc. The way you view data can be table or record based depending on what you prefer. When working with Oracle, DB2, SQL Server or Sybase you could view data dependencies among database objects. If you work with a mix of databases or many databases and want to build the queries at one convenient station, this handy tool can let you do that.

Publisher's description

Universal SQL Editor is a lightweight Intellisense-enabled database query tool.
It allows you connect Oracle, DB2, SQL Server, Sybase and any ODBC compliant database, and edit complex SQL with Intellisense-like autocompletion, highlight references, parameter hinting, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.
In additional, query results returned by this query tool supports grouping, filtering, searching, and can also be exported to Excel spreadsheet or as a set of SQL statements.
Key features of Universal SQL Editor:
* Support Oracle, DB2, SQL Server, Sybase and other ODBC compliant databases
* Powerful SQL editor that features Intellisense-like code completion, highlight references, parameter hinting, syntax highlighting, SQL formatting, multiple levels of undo and redo, column mode edit, code folding, etc.
* Convenient query tool that supports grouping, filtering and searching query results
* Fast and low memory consumption
Universal SQL Editor
Universal SQL Editor
Version 1.6.9
Free Download

User comments

Rate this program