This is a prerelease version.

View latest

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.

See some practical examples.

DROP VIEW [IF EXISTS] view_name

Parameters

The DROP VIEW statement accepts the following parameters.

The view_name parameter is required.

Parameter Description

IF EXISTS

Do nothing if the view does not exist.

view_name

The name of the view to delete.

Permissions

Enterprise Edition

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

Examples

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

DROP VIEW IF EXISTS highPerformingEmployees;