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.

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.

To make changes to table data using a view
Expand the database that includes the view in Object Explorer, then Views.
Select Edit Top 200 Rows from the context menu when you right-click the view.
To return the rows to be updated, you may need to edit the SELECT statement in the SQL pane.