# sql:delete

`sql:delete` performs an SQL DELETE statement. This causes a set of rows to be selected from a given table and deleted.

The attributes are as follows:

connection | The database connection. This is mandatory, the value is an expression, which must evaluate to a database connection object as returned by `sql:connect`.
table | The table containing the rows to be deleted. This is mandatory, and the value must be known statically (it cannot be defined as an attribute value template).
where | The conditions to be applied (the contents of the WHERE clause of the select statement). This is optional, if present the value is an attribute value template whose value is a SQL conditional expression. If omitted, all rows in the table are deleted.

Next