Overview

DELETE FROM table_name [ WHERE condition ]

Description

Deletes the rows that match the WHERE clause from a table, or deletes all the rows if the WHERE clause is not specified.

Examples

--- Delete matching rows
DELETE FROM lineitem WHERE shipmode = 'AIR';

--- Delete matching rows
DELETE FROM lineitem
WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');

--- Clear a table
DELETE FROM orders;

Limits

Some connectors may not support DELETE.