A modification query may cause rows in a view to disappear if a column in the WHERE clause of the view definition is changed by an UPDATE statement.

Question

Quizplus · Accepted Answer

When a modification query such as UPDATE is executed on a view that contains a WHERE clause, if the column in the WHERE clause is modified, some rows may no longer meet the criteria and will disappear from the view.

A Modification Query May Cause Rows in a View to Disappear