DELETE Statements Step by Step

A compact DELETE book for readers who need exact finite row-removal behavior: table-before-delete, WHERE choosing rows, TRUE rows removed, no-match unchanged output, multiple removed rows, UNKNOWN rows staying, an explicit all-rows predicate, and guarded expected facts.

DELETE Statements

Table before DELETE
WHERE Chooses Rows
DELETE Removes TRUE Rows
No Matching Rows
Multiple Rows Removed
UNKNOWN Rows Stay
Explicit All-Rows DELETE
Honest by Construction