<?xml version="1.0" encoding='utf-8'?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="card1" title="Delete (SQL) - Page 6 - Wikipedia">
<p>
<a accesskey="1" href="page.php?w=Delete_(SQL)&amp;p=5">1.Previous</a><br />
<a accesskey="3" href="page.php?w=Delete_%28SQL%29&amp;p=7">3.Next</a>
</p>
<p>automatically trigger the second:<syntaxhighlight lang="sql"> DELETE FROM pa WHERE pid=1;</syntaxhighlight></p>

<p><big>Features</big></p>
<p>
* It is a DML (Data Manipulation Language) command, therefore the following commands are used for this command: COMMIT and ROLLBACK<br/>
* Deletes all or some records from the table, you can limit the records to be deleted by using the WHERE clause<br/>
* Does not free the space occupied by the data in the table (in the TABLESPACE)<br/>
* Does not reset the SEQUENCE value assigned to the table<br/>
* DELETE works</p><p>
<a accesskey="1" href="page.php?w=Delete_(SQL)&amp;p=5">1.Previous</a><br />
<a accesskey="3" href="page.php?w=Delete_%28SQL%29&amp;p=7">3.Next</a>
</p>

<do type="prev" label="Search">
        <go href="search.wml"/>
</do>

</card>
</wml>
