DROP VIEW

Removes a view.

Syntax

DROP VIEW [ IF EXISTS ] <view_name>

Parameters

[ IF EXISTS ] Optional

When included, the command will succeed regardless of whether the view existed. If this clause is not specified, the command will fail if the view to be dropped does not exist.

---

<view_name> String

The path of the view that you want to drop.

Examples

Drop a view

DROP VIEW demo.example_view

Drop a specific view from a source

DROP VIEW Weather.SFWeatherElevation"Weather Conditions"