O'Reilly logo

SQL: Visual QuickStart Guide by Chris Fehily

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required