A single-table view is not updatable if all of the columns of the base table are not included in the view.

Name: A single-table view is not updatable if all of the columns of the base table are not included in the view.
Brand: Quizplus
Rating: 4.9 (33 reviews)

Question

Quizplus · Accepted Answer

A single-table view can be updatable even if not all columns of the base table are included in the view, as long as the view includes all columns that are part of the primary key or required for the update operation to comply with any NOT NULL constraints.

A Single-Table View Is Not Updatable If All of the Columns