The auto-join feature is disabled by default. The Query Builder can be configured to use both kinds of rules to automatically join the tables you add to the query builder. For instance, in the figure above, the EMPLOYEES table has a column named DEPARTMENT_ID, which refers to the column with the same name in the DEPARTMENTS table. Other schemas use column names to indicate these relationships. Some database schemas declare how tables are related using primary and foreign keys. The default join type is an Inner join and the default condition is 'equal to' (=), represented as an icon with overlapping circles with the shared area shaded and an equal sign below them. If more than one join condition is needed, link additional columns in the two tables by dragging and dropping the columns in the same way as for the first join condition. The two columns now represent a join condition, shown in the graph as a link between the columns. To join two tables, select the column in the source table window with the mouse, drag it to the target table column, and drop it. An asterisk ('*') can be used as a wildcard for any characters. It lists tables matching the search criteria as you type it in the search text field. Columns selected for the query result set also appear in the Columns and Sorting details tabs.Īn alternative to dragging and dropping tables into the Query Builder is to use the Quick Table Add dialog. Use the check box in front of each name to select whether the column should be included in the query result set. Under the table alias field is a list of all table columns. If a table alias is specified, it is used in the Query Builder and the generated SQL statement to refer to this table. You can select multiple tables and/or views and drag and drop them together.īelow the title is a text field where an optional table alias can be entered. When the table is dropped in the diagram area, it is shown as a window with the table name as the window title. To add a table, drag it from the object tree to the diagram area of the Query Builder. Then select and drag nodes from the tree into the diagram area. To add tables using drag and drop, make sure the database objects tree and the table and/or view objects are visible. You can also load a query from the SQL Editor into the Query Builder, as described in detail below. The first three buttons automatically change the display to the SQL Editor. The sixth button is a drop-down menu for selecting what to show below the diagram area: query details or the SQL preview.The fifth button opens a dialog that lets you add tables matching a search criteria,.The fourth button copies the query to the system clipboard,.The third button adds the query last in the SQL Editor,.The second button replaces the content of the SQL Editor with the query SQL, without executing it,.The first button (from left) replaces the content of the SQL Editor with the query SQL and executes it,.To copy the current query from the Query Builder to the SQL Editor, use the toolbar buttons at the top of the Query Builder: Clicking these buttons changes the display, but does not copy the query from one display to the other. The easiest way to jump between the Query Builder and the SQL Editor is by clicking the vertical control buttons to the right in the SQL Commander. Make sure that the controls in the top section of the Query Builder are set correctly. To create a query, open the query builder using the SQL Commander->Show Query Builder menu choice or click the vertical Query Builder button in the SQL Commander.

This document talks only about Tables even though the Query Builder supports both table and view objects.

Dbvisualizer query analyzer