Deleting a SQL Server view is simple:
Select Views from the Objects list.
Right-click the view that you want to delete.
Select Delete from the pop-up menu. The Drop Objects dialog box appears (see Figure 7.17).
Figure 7.17. The Drop Objects dialog box allows you to drop a view.
If you want to look at the view's dependencies, click Show Dependencies. The Dependencies dialog box appears (see Figure 7.18).
Figure 7.18. The Dependencies dialog box shows you what other objects a view depends on.
Click Close when you are done ...