How to delete a view (Enterprise Manager)

To delete a view

1. Expand a server group; 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