How to delete a view (Enterprise Manager)
SQL Server 2000
To delete a view
- Expand a server group, and then expand a server.
- Expand Databases, expand the database in which the view belongs, and then click Views.
- In the details pane, right-click the view, and then click Delete.
- To see how deleting this view will affect the database, click Show Dependencies.
- Click Drop All.