Translations of this page?:

Delete Data

Deletes data from an existing table

Samples

<delete tableName="People">
    <where>id=2</where>
</delete
<delete tableName="People">
</delete>

Available Attributes

tableName Name of the table to delete data from
schemaName Name of the table schema

Available Sub-Tags

where [TEXT] Where clause for delete statement

Database Compatiblity

MySQL No Issues
PostgreSQL No Issues
Oracle No Issues
MS-SQL No Issues
Sybase No Issues
DB2 No Issues
Derby No Issues
HSQL No Issues
H2 No Issues
Caché No Issues
Firebird No Issues
MaxDB No Issues
SQLite No Issues

Automatic Rollback Support: NO

 
manual/delete_data.txt · Last modified: 2008/09/20 10:00 (external edit)