Removes one or more views from the database.
drop view [databasename], [owner].view
is the name of the view to be dropped. The name must be a legal identifier and cannot include a database name.
drop view new_price
Each time a view is referenced, another view or stored procedure checks the existence of the view.
