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.