Specify data to update in a table (SET clause)

These steps are part of the larger task of creating an UPDATE statement. When you complete the steps for specifying data to update into a table, return to Create an UPDATE statement.

To specify data to update in a table:

  1. In the Outline view, click the SET (Row values) node. A list of columns in the table that you selected is displayed in the Details area. The names and data types of the columns are listed.
  2. In the Value column, specify update values. You can: Blank column values are omitted from the update list.

Return to Create an UPDATE statement.