====== DELETE ====== Synopsis -------- .. code-block:: none 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.