{{ transformations:DeleteDbRowsAction.png}}
====== DELETE DATABASE ROWS ======
Category: Workflow / External\\

\\ 
=====Description=====
This action deletes rows from a database table where the filtering clause of the query is satisfied (i.e. the WHERE statement in the generated SQL). Column selections and other settings of the query are ignored.

\\ 
=====Action settings=====
Selecting the "Edit query" button opens the Query Editor for selecting the Connector and entering SQL queries.
^ Setting  ^ Description  ^
|Connector<sup>*</sup>|Select or create a connector to the database.|
|New query|Enter a SQL query defining the rows to be deleted.  Queries can be saved as EasyMorph .query files for future use.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\ 
=====Remarks=====
Under the hood, rows are deleted using SQL DELETE statement (with the WHERE statement from the query). The operation is //atomic// meaning that either all satisfying rows are successfully deleted, or nothing is deleted (in case of some failure).

Using a query in the transformation properties has the convenience of previewing what rows will be deleted before actually deleting them.

Note that this operation can't be undone -- database rows are deleted forever.

\\ 
=====See also=====
  * [[transformations:sqlcommand|Database command]]
  * [[transformations:deletedbrowsbykeys|Delete matching database rows]]
  * [[transformations:updatedb|Update database table]]
  * [[:connectors|Information on connectors]]