DROP LIVE VIEW
Permanently deletes a live view and all of its data. For a conceptual overview, see Live views.
Syntax
DROP LIVE VIEW
DROP LIVE VIEW [ IF EXISTS ] viewName
Parameters
| Parameter | Description |
|---|---|
viewName | Name of the live view to drop |
IF EXISTS | Suppress the error if the view does not exist |
Examples
Drop a live view
DROP LIVE VIEW trades_ma;
Drop only if it exists (no error if missing)
DROP LIVE VIEW IF EXISTS trades_ma;
Behavior
| Aspect | Description |
|---|---|
| Permanence | Deletion is permanent and not recoverable |
| Space reclamation | Disk space is reclaimed asynchronously |
| Active queries | Existing read queries may delay space reclamation |
| Permissions | On Enterprise, the view's access-control grants are removed with it |
warning
This operation cannot be undone. The view and all of its precomputed data are permanently deleted.
Permissions (Enterprise)
Dropping a live view requires the DROP LIVE VIEW permission on the specific
view:
Grant drop permission
GRANT DROP LIVE VIEW ON trades_ma TO user1;
The view creator automatically receives this permission with the GRANT option.
Errors
| Error | Cause |
|---|---|
live view name expected | The name refers to a table or view that is not a live view |
live view does not exist | The view does not exist and IF EXISTS was not specified |
permission denied | Missing DROP LIVE VIEW permission (Enterprise) |