Delete from Table
Category: Table
This activity allows you to delete rows from a table. To use this activity, you need to provide:
- An input table to delete rows from.
- 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.