To modify table data through a view

1. In Object Explorer, expand the database that contains the view and then expand Views.
2. Right-click the view and select Edit Top 200 Rows.
3. You may need to modify the SELECT statement in the SQL pane to return the rows to be modified.