Restrictions on Updating Data through Views

You can insert, update, and delete rows in a view, subject to the following limitations:

1. • 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.
2. • You can't directly modify data in views based on union queries. You can't modify data in views that use GROUP BY or DISTINCT statements.
3. • All columns being modified are subject to the same restrictions as if the statements were being executed directly against the base table.
4. • Text and image columns can't be modified through views.
5. • There is no checking of view criteria. For example, if the view selects all customers who live in Paris, and data is modified to either add or edit a row that does not have City = 'Paris', the data will be modified in the base table but not shown in the view, unless WITH CHECK OPTION is used when defining the view.