User Guide

132 Chapter 8 Accessing Data Sources
Using SQL Builder for database queries
SQL Builder is a powerful visual tool that you can use to build, test, and save SQL
statements for use in application data queries. You can copy a SQL code block
directly into your application or insert it into a cfquery tag. You can also use SQL
Builder to test your queries.
To open SQL Builder, do one of the following:
• In the Database tab, right-click a database name or a table and select New Query.
• Select Tools > SQL Builder. In SQL Builder, select a database from the drop-down
list, and click New Query.
• Open the
cfquery tag editor and click New Query.
In the Select Table dialog box (shown in the following graphic), select the table
that you want to query against, and click Select.