Updating a view sql server dating websites relationships

Assume you created the below view: The Answer lies on if the view is an UPDATABLE VIEW or a NON UPDATABLE VIEW.

An updatable view is a view which contains all the not null columns from the underlying table.

So you can do something like: More explanation on Srinivas answer on the point of..

Well you can delete from a view if that is what you are asking, but you can't have a view that deletes information.

The view is a portion of data from the underlying tables.

If you have the Northwind database you can see that it has several views installed by default.

The view "Current Product List" lists all active products (products that are not discontinued) from the "Products" table.