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 orders:

DELETE FROM orders;