Learn SQL Database Programming

Learning how to update or delete a view

If you want to update a view (change the view definition), you can execute the following query:

USE lahmansbaseballdb; ALTER VIEW parksalias ASSELECT parkalias, parkkey, parkname, city, state, countryFROM parks_copyWHERE parkalias IS NOT NULLWITH CHECK OPTION; 

The difference is that you use ALTER VIEW instead of CREATE VIEW.

If you want to delete a view, you can execute the following query:

USE lahmansbaseballdb; DROP VIEW playergameinfo; 

By dropping the view, it has been deleted from the database.