Page History

The Visual Query Builder is designed to enhance productivity and simplify SQL query building tasks by allowing dragging and dropping multiple tables, views and their columns in a workbook to generate SQL statements. The Query Builder Workspace contains a Data Pane, decks for SQL clauses, a tabbed Diagram Pane and an SQL Pane. The Data Pane makes it easy to navigate between object types and schemas within a specific database connection. Objects are dragged into and within the Query Builder interface to create SQL based on your database schema, tables, views or columns. Dragging objects from the Data Pane or the Diagram Pane to any of the configurable decks for SELECT, WHERE, GROUP BY, HAVING and ORDER BY SQL clauses writes out the corresponding SQL as you go. Based on what you've dragged into the decks, the visual Query Builder generates a complete SQL statement that can be executed. Features like JOINs, UNIONs, Subquery in SELECT, Derived Tables and the Index Manager save you time and make the process of building queries more powerful and intuitive. 

...