Feature TourFeature Tour

Query Builder

Previous Next

The Query Builder provides an easy way to develop database queries. The query builder uses a point-and-click interface and does not require in-depth knowledge about the SQL syntax. The generated SQL may be configured to use the standardized JOIN syntax or WHERE conditions, delimited identifiers and qualifiers.

 
The query builder is a very useful feature used to build SQL select statements graphically. Pick tables in the database browser and drag them into the query builder diagram area or use the quick-add feature in the query builder. Then draw lines between columns in one table node and attach to columns in another table node. These lines represent the joins in the generated SQL. The tabs below the diagram area are used to specify any COLUMNS, WHERE, ORDER BY and GROUP BY clauses.
Table Diagram and Join Properties
In addition to the previous screenshot the query builder supports loading an existing SQL statement so that it can be edited in the query builder.
Column Select list
Once you are satisfied with the query, just pass it on to the SQL Commander for test execution. If you need to make any refinements just switch to the query builder and continue editing the query.
Generated and test SQL
Feature DbVisualizer
Pro		 DbVisualizer
Free
» Design queries with a few mouse clicks
» No SQL expertise is required
» Adapts the generated SQL for the actual database
» Reverse engineer a SELECT statement
» Auto Join of columns by primary/foreign key or name