Unparalleled SQL Editor

A lot of SQL Editors promise AutoComplete - but most are limited to only table and column names, and only for a certain set of commands. Clarity takes this concept one step further, and shows you complete step-by-step AutoComplete information for most SQL commands you'll ever use. Need to know what the syntax is for an ALTER TABLE command ? How about a CREATE INDEX ? Just type in a couple of letters of your command, and let Clarity take care of the rest. You'll never type in the wrong syntax again

Need to execute a procedure? type in the procedure name and Clarity will display the parameters as a tooltip. Hit TAB, and Clarity will automatically insert the parameters into your script, allowing you to tab through the list of parameters. Say goodbye to manually looking up parameters.

As you're typing your SQL, Clarity will automatically hyperlink table and procedure names, so you can quickly view the definitions or data for the given tables or procedures.

And of course, Clarity offers all the standard editor features such as syntax coloring, parenthesis and quote matching, and line numbering, features that you would expect from any decent editor.

Powerful History Manager

As you're running your scripts, making data changes2 or viewing object definitions, Clarity will keep track your operations, and display them in the easy to use History Pane. Using the History Pane, you can easily re-run a SQL command or an operation just by ctrl-clicking it. Made table changes but want to roll them back ? Clarity will even allow you selectively roll back certain rows. Searched for some database objects ? Re-run your search at a later time just using one-click.

Graphically Edit Everything

From server configurations, to table data - Clarity lets you edit most objects using easy to use Graphical Designers. Clarity offers graphical designers for the following database objects ... Alerts Aliases Databases Defaults Groups Functions Indexes Logins Messages Operators Roles Rules Schedules Scheduled Tasks Server Roles Tables Users

In addition, Clarity allows you to easily edit your table data graphically, even if your table contains image data. Use the 'Apply Lookup Table' feature to lookup IDs from another table, or use 'View Related Rows' to view related data from another table ..

Step Through Your Code

Clarity features a powerful built-in SQL debugger that is ready to work out of the box. Use it to step through, or over, your SQL scripts and stored procedures. You can easily set breakpoints, and inspect local and watch variables. Clarity even lets you modify the value of your variables during a debug session.

Compare Objects Easily

Clarity let's you compare two text sources (any text sources, whether they are text files, or object definitions directly from the database) and shows them as side by side views. Comparing data between two tables (or any data sources) is easy with the 'Compare Data' option. And finally, you can compare two databases for all there data and objects.

But if you're going to compare, why stop there ? Clarity can automatically merge them into a new text file if you're comparing texts. If you're comparing data, you can create a merged resultset, or just sync the table data in place using one click of the button.

Feature Summary

• Configurable workspace with dockable panes
• Unlimited¹ number of SQL editors with syntax coloring, parenthesis/quote matching and multi-level undo.
• Comprehensive auto-complete, and object name hyperlinking.
• Unlimited¹ number of resultset windows.
• Grouping/Sorting/filtering of resultsets.
• Import/export results in multiple popular file formats.
• View results in grid/text/form view format.
• View thumbnail images for image columns in your resultset
• Graphically edit table data, with automatic lookups
• View all related data from another table using 'View Related Rows'
• Quickly view list of most server objects
• Graphically create or edit most server objects
• Powerful History Manager displays and allows you to re-run (or undo, in some cases) the following ..
  • SQL commands
  • Database object searches
  • Database object definition lookups
  It also allows you to rollback the following operations ..
  • Database object drops
  • Table data edits
  • Truncate tables
• Compare (and merge) scripts or table data
• Compare two databases for content
• Integrated SQL Debugger
• Reverse-engineer database ER diagram
• Chart resultsets in bar-chart, pie-chart or line-chart formats
• Monitor server performance/space usage using Performance Monitors

And more ..