DROP VIEW
Removes a view from the current database.
Syntax
DROP VIEW [schema_name.]view_name;
Description
This statement only removes the view definition from the database schema, without making any changes to the actual data in the underlying base tables.