Delete from Table
Use the Delete from Table activity to delete rows from a table.
Usage
Complete the following properties to use this activity:
- Select - Specify the following information or click the Variable Reference icon to choose a variable:
Input Table - Enter the table name. This should be the variable output from a workflow or activity.
Note: If you are unable to choose the table you want from the variable browser, ensure that the activity that created the table has the Persist Table check box checked in its properties.
- Row(s) - Click the radio button to specify how many rows are deleted:
- All Rows - Delete all rows in the table.
- Rows Matching Specified Criteria - Delete only those rows that match the Where Clause.
- Where Clause - Enter the criteria for selecting rows to delete or click the Variable Reference icon to choose a variable.
Example
This example shows a Where Clause that will only delete rows where the id is equal to 1:
Sample Workflows
The following sample workflows are available in our repository’s workflows folder to help you get familiar with this concept. These can be imported using the instructions in Import Git Content or you can click the workflow to view it in GitHub.