---
title: "Delete MV and all its data"
method: DELETE
path: "/views/{name}"
tags: ["Materialized Views"]
---

# Delete MV and all its data

`DELETE /views/{name}`

Atomic deletion. If the view has cascading dependents, returns `409`.
Use `?force=true` to delete the view and all dependents.

## Path parameters

- `name` string, required

## Query parameters

- `force` boolean

## Response `204`

Deleted

## Other responses

- `404` — Resource not found
- `409` — View has dependents

---

[API](https://skmtc.net/lynxbase/apis/lynxdb-api.md) · [All operations](https://skmtc.net/lynxbase/apis/lynxdb-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/lynxbase/lynxdb-api/revisions/4363a070c444/schema)