A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is

Title: How to Delete a View in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of deleting a view in Microsoft SQL Server 2000. After a view has been created, you can delete the view if it is not needed, or if you want to clear the view definition and the permissions associated with it. When a view is deleted, the tables and the data upon which it is based are not affected. Any queries that use objects that depend on the deleted view fail when they are next executed, unless a view with the same name is created. However, if the new view does not reference objects expected by any objects dependent on the new view, queries using the dependent objects fail when executed.

If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.