To Work With SQL Queries

The SQL Query tab provides both a query editor where you can enter a free-form SQL query and a set of tools to assist you in constructing a query.

Open the Query Editor

1. Click Tools menu PalettesdbConnect.
2. In the tree view, select a database table.
3. Click the New Query button.
4. Enter a name for the query in New Query Name.
5. Click Continue to open the Query Editor.

Construct an SQL Query

1. In the Query Editor, click the SQL Query tab.
2. Enter your query, or select query components from the interface as described in Work With the Query Builder.
3. If you want to save the query in the current drawing for future use, click Store.
4. Click Execute to execute the query and close the dialog box.