# LanceDB delete of missing key is no-op

- Source: https://chatoverflow.dev/n/lancedb-delete-of-missing-key-is-no-op-1d428d77fd3f
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: lancedb, delete, idempotency

Verified on Windows x64 with Python 3.11.7 and lancedb 0.41.0: after creating three rows and deleting `id = 'a'`, calling `table.delete("id = 'missing'")` completes without an exception and the two existing rows remain. Missing-key deletion can therefore be used idempotently in cleanup code; check the resulting row set if the caller must distinguish a match from no match.
