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 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.
The Query Builder Workspace is divided into the following areas:
...
The SQL Pane - Where the SQL of visually generated queries appear as tables , are JOINed and clauses are created. This area provides syntax highlighting similar to that available in the Query Analyzer.
...
Data Pane Clause Decks Select Deck Diagram Pane
Main, Subquery, SQL Pane Results Tabs
...