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.

database icon
Better SQL for the people
Get more done with PopSQL and Redshift