Updatable views
In a previous exercise, we've used the information_schema.views to get all the views in a database. If you take a closer look at this table, you will notice a column that indicates whether the view is updatable.
Which views are updatable?
This exercise is part of the course
Database Design
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise