Designing SQL Statements

You can use the SQL Statement Builder to create several different kinds of SQL statements. These statements can request information from the database (SELECT statements) or request modifications to the database (UPDATE and DELETE statements), add new data to the database (INSERT statements) or execute stored procedures (CALL statements).

You can create, load, and delete statements from the menus or with the graphical interface. Refer to the following sections:

For information on creating statements with advanced expressions and criteria with the SQL Statement Builder, see the Building Precision SQL Statements chapter.