Table Update operator in SQL Server execution plan

The table update operator is generated when we are doing the updating in our query. It means this operator is responsible for modifying the existing rows when an update statement is executed.

Icon for Table Update Operator

See the example

Here we are updating the record in a table

Execute the below query

UPDATE employees SET    employeename = 'Bagesh Kumar' WHERE  employeeid = 1

See the execution plan