Link Search Menu Expand Document

Delete from Table

Category: Table

This activity allows you to delete rows from a table. To use this activity, you need to provide:

  1. An input table to delete rows from
  2. Criteria for selecting rows to delete

You can either select to delete all of the rows in the table or provide criteria in the Where Clause. This sample shows a clause that will only delete rows where the id is equal to a 1:


Writing a Where Clause

See the Where Clauses page.


Hints

  • If this activity isn’t letting you select the table you want, check that the activity creating the table has Persist Table checked on its properties.

Sample Workflows

The following sample workflows are available in our repository’s workflows folder to help you get familiar with this activity. These can be imported using the instructions here or you can view the workflow in GitHub by clicking on it.