SQLConsole (SQLC) is the only tool you need to author SQL scripts and queries with ODBC connectivity. SQLC includes a Query Designer that allows for the visualmodeling of SQL queries. As easy as dragging and dropping tables and joins the most complex of queries can be developed in mere minutes. Full support forcorrelated subqueries, totally configurable SQL functions and target mapped function drag and drop operations. SQL editors are context sensitive providingautocomplete of SQL keywords and table or view columns.
SQLC provides the end user with a fully integrated set of development tools for data manipulation and datadefinition. Complete with a metadata view of the underlying data structure, the end user is presented with a total overview of the data environment.
FeatureList:
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 dropfunctionality you can quickly and easily build an SQL query comprising of all manner of joins, search conditions, functions and even with an unlimited numbers ofsubqueries.
Stepbystep 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 oneproblem at a time.
Connection Manager maintains an interactive list of all open database connections and the metadata associated with each connection in adockable window called the Connection Manager. The information presented in the Connection Manager is central to all other operations within SQLC.
Metadata Viewof 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). Connectto 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 totalediting environment.
Intelligent AutoComplete feature that allows you to "autocomplete" 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 Hilighting of keywords, string literals and comments.
Function Editor that allows you tobuild complex expressions using drag and drop operations from the Connection Manager and Designer. The real power of the Function Editor is in its (enduserconfigurable) 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 SQLeditor 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 justa 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 evenfor those that have little understanding of SQL.
Fully Integrated Environment with the Connection Manager and Function editor, the SQL editor intelligentlyhandles 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 includingthe 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 youproductive within a few hours of using the software.
Unlimited Email Support is provided for all registered users of SQLC. Coupled with free upgrades to minorrelease 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.

http://rapidshare.com/files/332063169/SQLConsole_v2.10.9.rar