How to delete a view (Enterprise Manager)

To delete a view

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, expand the database in which the view belongs, and then click Views.
   
   
3. In the details pane, right-click the view, and then click Delete.
   
   
4. To see how deleting this view will affect the database, click Show Dependencies.
   
   
5. Click Drop All.

See Also

Deleting a View