IBM Db2 - Delete rows

This action lets you delete rows based on certain criteria defined by a WHERE condition.

WARNING

This action should be tested and used with care, as it will PERMANENTLY delete rows in your table.

Delete rows

Input fields

Table

Required field

Select the target table or view. Optionally, toggle the input to text mode to enter the name of the table or view name as text.

WHERE condition

Optional field

Specify the condition that must match the rows that the system deletes.
Warning: If this field is blank, the system deletes all rows.

Output fields

Rows affected

The number of deleted rows.