Universal SQL Editor 1.1.7.1

Universal SQL Editor 1.1.7.1 is an effective utility which allows you to connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, etc. and edit SQL scripts and queries with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.

Major Features:

1. Flexible Connectivity: Support Oracle, DB2, SQL Server, Sybase and other ODBC compliant databases
2. Easy Database Object Manipulation
   • Support scripting database objects (Support Oracle, DB2, SQL Server and Sybase only)
   • Support long script execution. If script was executed from the beginning to the end and error has occurred, the statement where the error occurred will be highlighted
   • Objects in database explorer will be updated automatically after execution of DDL statements
3. Powerful SQL Editor
   • Recognize complex SQL syntax, such as, derived table, common table expression (CTE), nested query, etc.
   • Support Intellisense-like code completion that supports wildcard search, parameter hinting and tooltip information
   • Support SQL formatting; include letter case conversion, for example, "TITLECASE" -> "TitleCase", "CAMELCASE" -> "camelCase", etc.
   • Support line revision marks, split view, full screen edit, drag-and-drop edit, column mode edit, code folding, widlcard search and replace, multiple levels of undo and redo, Unicode and DOS/UNIX/MAC formatted files
4. Convenient Query Tool
   • Allow grouping, filtering, searching, editing and sorting
   • Table and record views to see data the way you like it
   • Query results can be exported to Excel spreadsheet or as a set of SQL statements
5. Other Useful Features
   • Convenient to view information on dependencies between database objects (Support Oracle, DB2, SQL Server and Sybase only)
   • Low memory consumption
   • Additional features can be implemented as plug-in DLLs
     

Enhancements:

• Support search code completion list by wildcards,
• Improve date/time handling and usability

Requirements:

• Pentium or compatible processor
• Windows NT 4.0 / 2000 / XP / 2003 / Vista / 7
• ODBC driver
• Adobe Reader or compatible PDF viewer (Optional)