Features

Following list describes the main features of Universal SQL Editor:

Flexible Connectivity

  • Support ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc.

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

Powerful SQL Editor

  • Recognize complex SQL syntax, such as, derived table, common table expression (CTE), nested query, etc.
  • Support syntax highlighting, code completion and tooltip information
  • Support SQL formatting; include letter case conversion, for example, "TitleCase", "camelCase", etc.
  • Support line revision marks, split view, full screen edit, drag-and-drop edit, column mode edit, code folding, multiple levels of undo and redo, Unicode and DOS/UNIX/MAC formatted files

Convenient Query Tool

  • Allow editing, grouping, searching, filtering 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

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