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:
- 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.
- In the Value column, specify update values. You can:
- Type a value.
- Click NULL or DEFAULT.
- Click Expression to open a window
where you can create an expression.
- Click List Values to open a window where you can view a list of existing values for the selected column.
Blank column values are omitted from the update list.
Return to Create an UPDATE statement.