Deletes one or more rows from a table.

Syntax

---

DELETE FROM <TableName>
[WHERE <FilterCondition>]

Usage

---

Use this statement to delete one or more rows from a table.

WHERE Clause

Use the WHERE clause to limit the rows that are deleted to those that satisfy a boolean SQL expression.

Examples

---

-- This DELETE statement deletes
-- all rows from the Orders table for the
-- year 2006

DELETE FROM Orders
WHERE OrderDate BETWEEN DATE '2006-01-01' AND DATE '2006-12-31'

Required Privileges

---

The current user must be granted the DELETE and SELECT privileges on the target table. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: