SQL views are updatable when the view is based on a single table with no computed columns,and all non-null columns are present in the view.

Question

Quizplus · Accepted Answer

If the view is based on a single table with no computed columns, and all non-null columns are present in the view, then it is possible to update the view. However, if the view is based on multiple tables or has computed columns, it may not be updatable.

SQL Views Are Updatable When the View Is Based on a Single