Delete with a view

You can use a DELETE statement on a modifiable view as if it were a table. The database server deletes the correct row of the underlying table.