17.11. DELETE
Synopsis
DELETE FROM table_name [ WHERE condition ]
Description
Delete rows from a table. If the WHERE
clause is specified, only the
matching rows are deleted. Otherwise, all rows from the table are deleted.
Examples
Delete all line items shipped by air:
DELETE FROM lineitem WHERE shipmode = 'AIR';
Delete all line items for low priority orders:
DELETE FROM lineitem
WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');
Delete all orders:
DELETE FROM orders;
Limitations
Some connectors have limited or no support for DELETE
.
See connector documentation for more details.