Learn SQL Database Programming

Learning how to modify data returned in a view

You can insert, update, and delete data with the help of a view. You just have to use the view name in your INSERT, UPDATE, or DELETE statements instead of a table name.

Whatever permissions a user has to the underlying table(s) will determine if they can insert, update, or delete via a view.

In order to insert and update records via a view, there is one more thing to know about view creation. There is WITH CHECK OPTION, which ensures that any data that's inserted or updated via a view conforms to the conditions specified in the view. Before you add a new view, you should create a copy of the parks table to ensure you don't update the original table. We are only doing this for this test case, ...