Removes the specified view, which was originally created by the CREATE VIEW statement. Because a view is purely a logical construct (an alias for a query) with no physical data behind it, DROP VIEW only involves changes to metadata in the metastore database, not any data files in HDFS.

Syntax:

DROP VIEW [IF EXISTS] [database_name.]view_name

Statement type: DDL

Cancellation: Cannot be cancelled.

Related information:

Views, CREATE VIEW Statement, ALTER VIEW Statement