Skip to content

Making an unupdatable view writable

A view joins students and colleges and is therefore not updatable. You want UPDATE student_details SET name = 'X' WHERE id = 9 to work and to change the student's name.

What makes this possible?