<?xml version="1.0" encoding="iso-8859-1"?> <?xml-stylesheet href="../make-menu.xsl" type="text/xsl"?><html> <head> <this-is section="sql-extension" page="delete" subpage=""/> <!-- Generated at 2011-12-09T20:47:22.916Z--><title>Saxonica: XSLT and XQuery Processing: sql:delete</title> <meta name="coverage" content="Worldwide"/> <meta name="copyright" content="Copyright Saxonica Ltd"/> <meta name="title" content="Saxonica: XSLT and XQuery Processing: sql:delete"/> <meta name="robots" content="noindex,nofollow"/> <link rel="stylesheet" href="../saxondocs.css" type="text/css"/> </head> <body class="main"> <h1>sql:delete</h1> <p><code>sql:delete</code> performs an SQL DELETE statement. This causes a set of rows to be selected from a given table and deleted.</p> <p>The attributes are as follows:</p> <table> <tr> <td content="para"> <p>connection</p> </td> <td content="para"> <p>The database connection. This is mandatory, the value is an expression, which must evaluate to a database connection object as returned by <code>sql:connect</code>.</p> </td> </tr> <tr> <td content="para"> <p>table</p> </td> <td content="para"> <p>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).</p> </td> </tr> <tr> <td content="para"> <p>where</p> </td> <td content="para"> <p>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.</p> </td> </tr> </table> <table width="100%"> <tr> <td> <p align="right"><a class="nav" href="close.xml">Next</a></p> </td> </tr> </table> </body> </html>