How to delete a view (Enterprise Manager)

How to Install SQL Server 2000

How To

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