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.
User comments