Skip to main content

​
DROP VIEW

Remove a view definition from the database. The underlying tables and their data are not affected.

​
Syntax

DROP VIEW [IF EXISTS] [schema-name.]view-name;

​
Description

DROP VIEW removes a previously created view. After the view is dropped, queries referencing the view name produce an error. The tables referenced by the view are unaffected.

​
Parameters

ParameterDescription
IF EXISTSPrevents an error if the view does not exist. The statement is a no-op when the view is absent.
schema-nameThe name of the attached database containing the view. Defaults to the main database if omitted.
view-nameThe name of the view to drop.

​
Behavior

  • Any triggers defined as INSTEAD OF on the dropped view are also removed.
  • If the view is a materialized view, the stored data is also removed.

​
Examples

​
Drop a View

DROP VIEW active_users;

​
Drop a View Only if It Exists

DROP VIEW IF EXISTS old_report;

​
Drop a View in an Attached Database

DROP VIEW aux.cached_stats;

​
See Also

  • CREATE VIEW for creating views and materialized views