DROP VIEW

The DROP VIEW statement deletes a view.

Syntax Summary

This code block is a quick reference with all the parameters that you can use with the DROP VIEW statement.

DROP VIEW [IF EXISTS] view_name

The DROP VIEW statement accepts the following parameters.

The view_name parameter is required.

Parameter Description

Parameter	Description
`IF EXISTS`	Do nothing if the view does not exist.
`view_name`	The name of the view to delete.

IF EXISTS

Do nothing if the view does not exist.

view_name

The name of the view to delete.

Enterprise Edition

If security is enabled, you can grant or deny permission for certain clients to use this statement. See SQL Permissions.

This section lists some example SQL queries that show you how to use the DROP VIEW statement.

DROP VIEW IF EXISTS highPerformingEmployees;