This is the documentation for CDH 5.1.x. Documentation for other versions is available at Cloudera Documentation.

DROP VIEW Statement

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.

Views, CREATE VIEW Statement, ALTER VIEW Statement

Page generated September 3, 2015.