8.12. DELETE

Synopsis

  1. DELETE FROM table_name [ WHERE condition ]

Description

Delete rows from a table. If the WHERE clause is specified, only thematching rows are deleted. Otherwise, all rows from the table are deleted.

Examples

Delete all line items shipped by air:

  1. DELETE FROM lineitem WHERE shipmode = 'AIR';

Delete all line items for low priority orders:

  1. DELETE FROM lineitem
  2. WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');

Delete all orders:

  1. DELETE FROM orders;

Limitations

Some connectors have limited or no support for DELETE.See connector documentation for more details.