Deleting Views

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 ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.