BackUp LevelNext

Building SQL Queries

Studio provides a powerful visual query builder to build, test, and save database queries with the Structured Query Language (SQL).

Choose one of these commands to open the Query Builder:

The Query Builder is designed to let you build different kinds of queries and then insert them into an application page. The Query Builder supports developing four types of SQL queries:

The Query Builder has three panes:

The Query Builder toolbar gives you quick access to many of its functions.

Query 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 to use for the query.

To create an insert, update, or delete query, choose the type from the Query Builder toolbar or right-click in the Table pane and choose the Query Type.


BackUp LevelNext

allaire

AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.