When a view includes columns from more than one table,updates can only be applied to the table that includes the primary key for the view.

Question

When a view includes columns from more than one table,updates can only be applied to the table that includes the primary key for the view.​

Quizplus · Accepted Answer

A view is a virtual table that is derived from one or more tables. When a view includes columns from more than one table, updates can only be applied to the table that includes the primary key for the view. This is because the primary key is used to identify the rows in the view. If updates were allowed to be applied to other tables, it could lead to data inconsistencies.

When a View Includes Columns from More Than One Table,updates