Use DROP DERIVED VIEW statements to delete a derived view.

DROP DERIVED VIEW Syntax

The DROP DERIVED VIEW statement accepts the name of the derived view to delete, as shown in the following example:

DROP DERIVED VIEW [<view_name>]

The following query deletes the derived view MyView. It can no longer be used.

DROP DERIVED VIEW [MyViewName]