SQL: Visual QuickStart Guide

Updating Data Through a View

An updatable view is a view to which you can apply INSERT, UPDATE, and DELETE operations to modify data in the underlying table(s). Any changes made in an updatable view always pass through to the base table(s) unambiguously. The syntax for the INSERT, UPDATE, and DELETE statements is the same for views as it is for tables; see Chapter 9.

A nonupdatable view is one that doesn’t support INSERT, UPDATE, and DELETE operations because changes would be ambiguous. Nonupdatable views are said to be read-only views. To change the data that appears in a read-only view, you must change the underlying table(s) directly.

Each row in an updatable view is associated with exactly one row in an underlying base table. For a view ...