 features Change Data In-Place, Without SQL
OmniView lets you visualize database content with just a few mouse clicks. Simply select a table
from a list and instantly see the table data in a data grid similar to a spreadsheet. But more than
that, you can add, edit or delete data in place...all without writing a single line of SQL.
(OmniView Table Worksheet - click image for full size)
Point-and-Click Filtering, Without SQL
OmniView lets you create simple or complex row filters, including joined tables, without knowing any SQL.
Just point and click your way through its visual expression builder which offers context-sensitive options
every step of the way.
(OmniView Point-and-Click Filtering - click image for full size)
Advanced SQL Query Editor
Point-and-click is great in certain circumstances, but sometimes you just have to be able to write SQL.
OmniView also provides a complete, full-featured SQL query editor which includes syntax highlighting,
auto-completion, and more. Plus datasets returned from a query can be examined using the same powerful
data grid features.
(OmniView Advanced SQL Editor - click image for full size)
More OmniView Features
| Standard | Professional |
|---|
| Intuitive, spreadsheet-like access to data for any table or view. | | |
| Fully editable data (add, update, delete) when data security allows. | | |
| Display table or view structure information | | |
| Advanced SQL query editor with syntax highlighting and autocompletion. | | |
| Use multiple worksheets simultaneously when working with multiple tables or queries. | | |
| Resizable text editor for text, ntext and long character data. Load and save text data from/to disk files. | | |
| Equivalent binary editor for image and binary data. | | |
| Point-and-click row filter designer let's you filter data without knowing SQL, including filtering by joined tables. | | |
| A complete SQL text editor is also available for writing raw SQL expression filters. | | |
| Quick filters let you immediately filter rows based on currently selected data. | | |
| Multi-level row grouping using simple drag-and-drop. Select the column to group by, and drag it into the grouping panel. | | |
| Sort data by a single column or multiple columns simply by clicking the column you want to sort. | | |
| Freeze columns in place so they remain in view while horizontally scrolling through a large number of columns. | | |
| Save all your custom settings for the data grid as a private view and recall the exact same display on new data at any time by simply selecting your private view from a menu. Private views can hold row filters, column positions and visibility, grouping, and sortation. | | |
| Organize tables and views into named groups you define. Keep related or frequently used objects together. | | |
| Print or export any dataset you create. | | |
| Access system tables and views with all the available grid features. | | |
| Execute stored procedures and examine result sets with all the available grid features. | | |
|
