Learn SQL Database Programming

Deleting data using a view

To delete the row in the parksalias view that corresponds to parkkey = 'ALB01', you can execute the following query:

USE lahmansbaseballdb;DELETE from parksalias WHERE parkkey = 'ALB01'; 

You won't receive an error, but it won't delete that row because it doesn't exist in the view. It exists in the underlying table, but since the view doesn't contain that row, a DELETE statement via the view won't be able to delete it.

The Output panel shows that zero rows were deleted, as shown in the following screenshot:

Let's try to delete the row you just inserted via the view with the help of the following query:

USE lahmansbaseballdb; ...