Table Writes

Delete a Row by Key

DELETE removes a matching key.

highlighted = computed this step

Delete a row by key

DELETE removes the row with the matching key.

matching key is removed\text{matching key is removed}

Apply the delete

Applied writes are 1, and final rows become 2.

final rows=2\text{final rows}=2

Write examples are tiny finite row modifications; SQL dialects, transactions, constraints beyond the visible key, triggers, indexes, concurrency, performance, and product behavior are out of scope.

Delete a row by key: base tableidnamepoints1Ada102Ben203Cy15 writes in orderstepkindkeydetail0delete3delete row write resultsstepkindkeystatusreasonbeforeafter0delete3appliedok32 final tableidnamepoints1Ada102Ben20 write factsfactvaluebaseRowCount3writeCount1appliedCount1rejectedCount0finalRowCount2keyColumnidrowOrderkey

Read the missing row

The deleted key is absent from the final table.

row removed\text{row removed}

Summary

Nothing else moves except the deterministic table order after recompute.

key order remains\text{key order remains}