Removes one or more views from the current database.
Transact-SQL Syntax
drop view [owner.]view_name[,[owner.]view_name]...
ODBC Syntax
DROP VIEW viewed_table_name [CASCADE|RESTRICT]
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
This removes the view new_price from the current database.
T-SQL allows you to drop multiple views in one statement, but ODBC does not. If multiple views are encountered, transformation generates multiple DROP statements.
ODBC allows the keywords CASCADE and RESTRICT to be used in the statement. Because T-SQL does not support this, these keywords are not generated during transformation.
Each time a view is referenced, another view or stored procedure checks the existence of the view.
