Microsoft® SQL Server 2008 R2 Unleashed

Data Modifications and Views

Data modifications are allowed through a view under certain circumstances. Views that meet these criteria are sometimes called updatable views. Updatable views can be referenced in an INSERT, UPDATE, or DELETE statement, and these statements ultimately affect the underlying table(s) in the view.

The following example contains a SQL statement to create an updatable view, followed by an UPDATE statement that performs a data modification using the view:

In general, updatable views are similar to the previous example. The following specific conditions allow a view to be updatable:

• Any data modification via a view must ...