How to Delete Rows in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use DELETE FROM ... WHERE, with USING to join another table. Deleted rows are only marked deleted; run VACUUM DELETE ONLY (or let auto vacuum do it) to reclaim the space.
DELETE FROM orders WHERE status = 'cancelled';Delete with a join
DELETE FROM orders
USING customers c
WHERE c.id = orders.customer_id
AND c.is_test_account;If you are deleting every row, TRUNCATE is far faster and reclaims space immediately, but it commits the transaction on the spot.
Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free