DROP VIEW

NOTE

This feature is included in the Premium software edition. Please see the Software editions documentation for details on the differences between Standard and Premium editions if you are subscribed to the Standard edition.

Description

Drops a view (logical view).

Syntax

DROP VIEW [IF EXISTS] [db_name.]<view_name>

Parameters

view_name: The name of the view to drop.

Examples

  1. Drop the view example_view from example_db.

    DROP VIEW IF EXISTS example_db.example_view;