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
Arguments
Details
Comparisons
See Also

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.

See Also

Statements:
CREATE VIEW Statement
DESCRIBE VIEW Statement
DROP TABLE Statement
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017