Not just another visual query tool, OmniView makes working with SQL Server database content quick and easy for a wide range of user skill levels. Database administrators and developers can examine and change data more rapidly and conveniently with OmniView than with the native tools provided with SQL Server. But other types of users often need to work directly with database content as well, including project managers, quality assurance teams, technical support staff, trainers…and sometimes even customers. Often these users are not as proficient with the more developer-centric SQL Server tools, but OmniView allows them to be more productive and lessens the workload on DBAs to support them.

OmniView allows you to examine data from any table or view just like a spreadsheet. You can add, change or delete data just as easily as you would within a spreadsheet, without writing any SQL queries whatsoever. In addition, you can create queries against data using a simple point-and-click interface that does not require any SQL knowledge. Build expressions by selecting fields, operators, and values from drop down lists. OmniView transforms this behind-the-scenes into the appropriate SQL and performs the query for you. Power users or SQL-savvy individuals can still write SQL expressions directly if they desire.

Entire SQL scripts can be created from scratch using OmniView's advanced SQL editor. The editor includes auto-completion features that provide drop down lists for database tables, SQL functions, and global variables. Write SQL quicker and more accurately without stopping to look up reference information. Any data returned by the query can be manipulated with the same powerful spreadsheet features described above.

OmniView is available in two editions: Standard and Professional. The Pro edition is more suitable for advanced users. Pro allows you to work with stored procedures and system tables.

Platforms: Win95 , Win98 , WinME , WinNT 4.x , Windows2000 , WinXP

System requirements: Not specified