SQL Query Builder

Create, edit, or run SQL statements using the SQL Query Builder graphical interface, which provides access to your database schema and objects so that you can quickly create or edit SQL statements without actually typing any SQL code. However, you also have the flexibility to add or modify the SQL code in the editor window.

The options in the SQL Query Builder change depending on the statement type you are building. By default, the statement type is SELECT.

• Creating an INSERT Statement From a Values Set
  Use SQL Query Builder to create an INSERT statement to insert new rows at the end of a table with the values you indicate for the specified columns.
• Creating an INSERT Statement From a Subquery
  Use SQL Query Builder to create an INSERT statement from a subquery.
• Creating an UPDATE Statement
  Use SQL Query Builder to create an UPDATE statement to update data in a table. You can explicitly set the values or derive them from the results of a build expression.
• Creating a DELETE Statement
  Use SQL Query Builder to create a DELETE statement to remove data from a specified table. By specifying one or more conditions, you can indicate which rows in the database table to delete. If you do not specify any conditions, all rows in the target table are deleted.
• Editing a SQL Statement
  Use SQL Query Builder to edit an individual SQL statement. You can only edit one SQL statement at a time.
• Running the SQL Statement Code
  Use SQL Query Builder to run an individual SQL statement and view its execution results.