|
Feature List
|
|
•
|
Visual Query Builder which provides you with a modeling environment to visually create the most complex of SQL queries in mere minutes. With drag and drop functionality you can quickly and easily build an SQL query comprising of all manner of joins, search conditions, functions and even with an unlimited numbers of subqueries.
|
|
•
|
Step-by-step Visual Modeling of the most complex SQL queries. Each clause of the query can be handled as a single task making it easy to focus on one problem at a time.
|
|
•
|
Connection Manager maintains an interactive list of all open database connections and the metadata associated with each connection in a dockable window called the Connection Manager. The information presented in the Connection Manager is central to all other operations within SQLC.
|
|
•
|
Metadata View of tables and views with constraints and dependencies such as primary keys, foreign keys and indexes. Column details with datatypes, default values, nullability, etc.
|
|
•
|
Quick Edit of views, stored procedures and functions.
|
|
•
|
Database Listing for the host server (subject to DBMS support of a configurable SQL command). Connect to any database even without an ODBC DSN entry.
|
|
•
|
SQL Query Editor goes beyond the bounds of what is necessary to take you to the luxury of providing a total editing environment.
|
|
•
|
Intelligent Auto-Complete feature that allows you to "auto-complete" reserved words and keywords with a simple keystroke.
|
|
•
|
Context Sensitive Editing monitors editor contents and keystrokes and will display a selectable list of table columns whenever the "dot" separator character is typed after a table alias or table name.
|
|
•
|
Syntax Hi-lighting of keywords, string literals and comments.
|
|
•
|
Function Editor that allows you to build complex expressions using drag and drop operations from the Connection Manager and Designer. The real power of the Function Editor is in its (end-user configurable) ability to map generic functions to target DBMS implementations on the fly. With a simple drag and drop, you can drag an expression into the SQL editor or Designer and have it mapped to the expected syntax of the target DBMS!
|
|
•
|
Function Mapping can be configured for any target DBMS by the end user with just a few minutes of editing. Once configured, SQLC will take all of the work out of building SQL expressions.
|
|
•
|
Easy to Learn user interface making SQL possible even for those that have little understanding of SQL.
|
|
•
|
Fully Integrated Environment with the Connection Manager and Function editor, the SQL editor intelligently handles drag and drop operations to prefix the correct table name or alias to columns as the text is dropped into the editor.
|
|
•
|
ODBC Driver Information including the full range of data that can be gathered from an ODBC 3.51 compliant driver.
|
|
•
|
Tutorial Exercises will enable you to straighten
the learning curve and have you productive within a few hours of using the
software.
|
|
•
|
Unlimited Email Support is provided for all
registered users of SQLC. Coupled with free upgrades to minor release
versions, guarantees that you will always have the latest software and
full support backup whenever you need it. We want you to be a success.
|
