Using SQL Builder

Studio provides a powerful visual tool to build, test, and save SQL statements for use in data queries. Select a query type from the SQL Builder toolbar or right-click in the Table pane and choose from the Query Type list.

Note To open SQL Builder choose one of these methods:

The SQL Builder interface

The following illustration shows the SQL Builder interface:

The SQL Builder is divided into four sections:

Writing SQL statements

SQL Builder opens a SELECT statement by default, since this is the most common type of query. If you have not chosen a table, you will be asked to select one.

SQL Builder supports four types of SQL statements:

The SQL pane does not support reverse editing, so any changes you make in this pane will not be made to the query in the Properties pane or the Table pane.