SQLConsole (SQLC) authors SQL scripts and queries with a drag-and-drop visual query designer. It features full support for correlated subqueries, totally configurable SQL functions, and target-mapped function drag-and-drop operations. SQL editors are context sensitive providing auto-complete 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 data definition. Complete with a metadata view of the underlying data structure, the end user is presented with a total overview of the data environment. Visual query builder 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 a SQL query comprising of all manner of joins, search conditions, functions, and even an unlimited numbers of subqueries. 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. The intelligent auto-complete feature 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. Unlimited e-mail support is provided for all registered users of SQLC.