Dropping a View

The formula to programmatically delete a view is:

DROP VIEW ViewName

Here is an example

DROP VIEW Personnel.StaffMembers;
GO