You can drop views from a database by using the
DROP VIEW statement. The syntax for
DROP VIEW follows:
DROP VIEW [ schema_name . ] view_name [ ...,n ] [ ; ]
You can drop more than one view by using one
DROP VIEW statement and listing all the targeted views, separated by commas. You should consider running the
sp_depends stored procedure against the targeted views before dropping them. This procedure lists the objects dependent on the view you are dropping.
You can also drop more than one view via SSMS. Simply select the
Views node in Object Explorer and then activate the Object Explorer Details window. The Object Explorer Details window displays all the views and allows you to select ...