DROP VIEW

Removes a view. The underlying tables and their data are retained.

Syntax

DROP VIEW [ IF EXISTS ] <name>

IF EXISTS skips the operation if the view is missing.

Examples

Remove the view from the CREATE VIEW example:

DROP VIEW IF EXISTS failed_requests