SQLConsole provides a visual query builder, SQL authoring, connection management, and context-sensitive editing. It also has intelligent auto-complete of keywords and supports all databases with ODBC. Additionally, it offers unlimited email support.
SQLC is equipped with many advanced features, including full support for correlated subqueries, configurable SQL functions, and target mapped function drag-and-drop operations. Additionally, SQL editors are context sensitive, which provides an auto-complete feature for SQL keywords and table or view columns, making the process easier for novices and experts alike.
One of the software’s major advantages is that it provides end-users with a fully integrated set of development tools for data manipulation and data definition. This allows users to have a metadata view of the underlying data structure, which presents a total overview of the data environment.
A major highlight of the software is the Visual Query Builder, a modeling environment that visually creates even the most complex SQL queries in mere minutes. Through its drag-and-drop functionality, users can build all types of queries, including joins, search conditions, functions, and unlimited numbers of subqueries with ease.
Another key feature of SQLC is the Connection Manager, which maintains an interactive list of all open database connections and the metadata associated with each connection in a dockable window. The information presented in the Connection Manager is central to all other operations within SQLC.
The software also provides an intelligent auto-complete feature, which allows users to “auto-complete” reserved words and keywords with a simple keystroke. Additionally, Context-Sensitive Editing feature monitors editor contents and keystrokes, displaying a selectable list of table columns whenever the “dot” separator character is typed after a table alias or table name.
Finally, SQLC offers unlimited email support for all registered users with free upgrades. This makes it a highly recommended software for anyone looking for a powerful yet easy-to-use SQL query builder.
Version 2.10.0: New Features