Create an UPDATE statement

You use an UPDATE statement to update data in an existing table.

In some environments, you cannot use SQL Assist to create UPDATE statements.

To create an UPDATE statement using SQL Assist:

  1. In the Outline view, click the main SQL statement properties node.
  2. In the Details area, click UPDATE. An UPDATE statement outline is displayed in the Outline view.
  3. Select a table to update (UPDATE clause).
  4. Specify data to update into the table (SET clause).
  5. Add search conditions to the UPDATE statement (WHERE clause).
  6. Click OK. The SQL Assist window closes and the generated SQL code is sent to the client application.

Related tasks
Add search conditions to an SQL statement (WHERE or HAVING clause)
Add expressions
Create a SELECT statement
Create an INSERT statement
Create a DELETE statement
Edit an SQL statement
Check SQL syntax
Run an SQL statement