DROP VIEW Statement

Removes a view from the database.

Category: Data Definition
Data source: SAS data set, SPD Server table, Aster, DB2 under UNIX and PC, Greenplum, HAWQ, HDMD, Hive, Impala, MDS, MySQL, Netezza, ODBC, Oracle, PostgreSQL, SAP HANA, Teradata

Syntax

DROP VIEW view [FORCE];

Arguments

view

specifies the name of the view to be removed.

FORCE

specifies that the view is removed without error processing.

Details

A view can be considered a virtual table. The view is formed by running a query expression against one or more tables. Dropping a view does not change any data in the database. Only the metadata that is associated with the view is deleted.
Any view on a dropped table can be dropped explicitly by using the DROP VIEW statement.

Comparisons

The DROP TABLE statement removes a table from the database. The DROP VIEW statement removes a view from the database.
Last updated: February 23, 2017