Working with Query Builder

Go Up to Session 5: SQL Management

1. From the Tools menu, select Query Builder.

   DBArtisan opens the Query Builder.

2. In the Tables/Views tab, right-click a table or view and select Add.
3. In the window that opens, select the columns to return the result. For example:

   

   Query Builder generates the query text in the lower SQL window.

   

   You can build advanced queries using the options supplied on the DML tab. You choose the type of query (SELECT, INSERT, and so on) using the dropdown on the Query Builder toolbar.

4. After the query is built, click the Execute button (green arrow) on the Query Builder toolbar.

   Query Builder displays results in the lower SQL window.

5. Close the Query Builder pane.

Proceed to ISQL Window.