User Guide

64
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.
To open SQL Builder choose one of these methods:
• Right-click on a database or a table in the Database tab and choose New Query.
• Click Tools > SQL Builder, select a database from the dropdown list, and click
New Query.
• Open the CFQUERY tag editor and click the New Query icon.
The SQL Builder interface
The following illustration shows the SQL Builder interface: