Restrictions on Updating Data Through Views You can insert, update, and delete rows in a view, subject to the following limitations: If the view contains joins between multiple tables, you can only insert and update one table in the view, and you can't delete rows.
You can't directly modify data in views based on union queries.
SQL Server FAQ SQL Server FAQ - Updating Data in a View By: (Continued from previous topic...) Can You Update Data in a View?
But if the question is "Can you update data in the underlying table through view? SQL Server will allow you to update data in the underlying table through a view.
The view is a portion of data from the underlying tables.Does this mean that I can only update fields in dbo.Staff (which is all I can currently achieve) In this context does the definition of 'base table' not extend to any subsequently joined tables?See "Key-Preserved Tables" for a discussion of key-preserved tables.If the view is defined with the WITH CHECK OPTION clause, then all join columns and all columns of repeated tables are non-updatable.In the columns for the view, the permissions for a column name apply across a CREATE VIEW or ALTER VIEW statement, regardless of the source of the underlying data.