How to Delete in Redshift

To delete rows in a Redshift table, use the DELETE FROM statement:

DELETE FROM products WHERE product_id=1;

The WHERE clause is optional, but you'll usually want it, unless you really want to delete every row from the table.

Shared queries and folders ✅ Version history ✅ One-click connection to Redshift ✅
Get more done, together, with PopSQL and Redshift