DELETE

What it is

DELETE removes matching rows.

When to use it

Delete only when retention and business rules allow it.

Syntax

DELETE FROM orders WHERE id = ?;

Example

DELETE FROM orders WHERE id = 42 AND status = 'draft';
-- Settled transactions should normally be retained, not deleted.

Common mistakes

Missing WHERE removes all rows; financial history may need immutable reversals instead.

Related topics