<?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 2010-10-29T18:20:48.427+01:00--><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>