BPM5 Documentation - Delete All Records from a Database Table

To delete all records from a database table, complete the following steps:

Check out and open the process you want to edit.
In the Toolbox pane, click Database. A list of activities is displayed.
Double-click or drag the Delete Database Records activity into the process.
Link the activity appropriately with other activities.
Right-click the Delete Database Records activity. A shortcut menu is displayed.
Select View Properties. The Delete Database Records window is displayed.
Click the Database and Table tab. The Database and Table to Delete Records from section is displayed.
In the Database field, click the System Resource icon. A list of the ODBC System Resources is displayed.
Select the relevant ODBC System Resource. The selected resource is displayed in the field.

Note:

If your system resource contains a data item in the connection string property, click Configuration values and enter a valid connection string for design-time, configuration purposes.
In the Table field, click the Table icon. A drop-down list is displayed.
Select the relevant database table. The selected table’s name is displayed in the field.
Click the Deletion Criteria tab. The corresponding screen is displayed.
Select the If the deletion action on any record fails, rollback and undo all deletions check box.
Click OK. You configured the activity to delete all records from a database table.

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Database Activities > Delete Database Records

Last modified at 7/31/2020 11:35 AM

Delete All Records from a Database Table // <![CDATA[ _spBodyOnLoadFunctionNames.push("setupPageDescriptionCallout"); // ]]>