How to: Delete Views from Databases (Visual Database Tools)
Views are saved with the database. When you delete a view from Object Explorer, it is also deleted from the database.
To delete a view from a database
Right-click the view you want to delete in Object Explorer.
Click Delete on the shortcut menu.
Click Yes in the confirmation message box.
See Also
Other Resources
Working with Views (Visual Database Tools)