DROP VIEW
Commands › Views · Admins only, through sercha_define or a tenant file
Removes a view.
Syntax
DROP VIEW [ IF EXISTS ] <name>
Parameters
| Parameter | Description |
|---|---|
<name> | A view. |
IF EXISTS | Succeed with a message when there is no such view. |
Usage notes
- A view a view preset keeps cannot be dropped by hand. DETACH PRESET makes it the tenant's own first.
- A materialized view is dropped with DROP MATERIALIZED VIEW.
- A model entity's or relation's view goes with DROP ENTITY or DROP RELATION.
Examples
DROP VIEW IF EXISTS open_orders
| result |
|---|
| view "open_orders" dropped |
Not supported
| Refused | Write instead |
|---|---|
| Several views in one statement | One DROP VIEW per view |
-- Refused by the engine
DROP VIEW open_orders, closed_orders