DB Delete (Filter)

Deletes all data rows from the selected database table that match the specified filter conditions.
The output table contains two columns. The first column is the number of rows affected by the DELETE statement. A number greater than or equal to zero -- indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution. The second column shows a warning message, if any.
Within the dialog, an SQL WHERE clause is interactively created by adding and grouping conditions.

Input ports

1. Type: DB Session
   DB Connection
   DB Connection to the database.

Output ports

1. Type: Table
   Delete Status
   KNIME data table with columns providing the number of affected rows in the database and warning message, if any.
2. Type: DB Session
   DB Connection
   Input DB Connection that can be changed to DB Data referencing the selected database table.