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.

sql

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 EditionThis feature requires Hazelcast Enterprise, a licensed edition of the Hazelcast Platform.

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.

sql

DROP VIEW IF EXISTS highPerformingEmployees;