Build SQL statements with SQL Assist

You can build your SQL statements interactively with the SQL Assist function. SQL Assist helps you to build select, insert, update, and delete statements.
  1. To start SQL Assist, select SQL Assist from the Edit menu in Run SQL Scripts. From the SQL Assist interface, you can choose tables to work with and build selection criteria. The statement is built in the bottom portion of the interface.
  2. Click OK to return the statement you built to the Run SQL Scripts interface.
  3. You can edit, run, and save your statement.
Related tasks
Query your database using the Run SQL Scripts interface