Skip to main content
Version: Current

Delete Records

Description​

The Delete Records activity removes records from a specified database table based on defined filter criteria. It enables controlled, automated data cleanup during workflow execution.

Common settings​

Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.

Design-Time Configuration​

The following properties define how the activity connects to the database and deletes records.

Connection Type​

Specifies the database engine (for example, SQL Server, Oracle, MySQL, PostgreSQL). Selecting the correct type ensures compatibility with the target database.

Connection Name​

Select a preconfigured database connection that defines the server, credentials, and security settings.

Schema​

Specifies the database schema that contains the target table.

Table Name​

Specifies the name of the database table from which records will be deleted.

Filter​

Defines which records are deleted. Build the conditions with Record Filters.

If no filter is supplied, the delete command has no WHERE restriction and can delete every row in the selected table. Supply an explicit filter for targeted deletion.

Timeout​

Specifies the maximum time (in seconds) that the activity will wait for the delete operation to complete.   The default value is 600 seconds.

Outputs​

Affected Records Count​

Returns the number of records that were successfully deleted.

This value can be used for:

  • Validation
  • Reporting
  • Conditional workflow logic

Execution settings​

Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.

Example: Delete a specific record​

Choose the connection, schema, and table. Build a filter where the unique OrderId equals the order to remove. Run against test data and check Affected Records Count. A count of 0 means no rows were deleted; more than 1 means the condition matched multiple rows.

Help improve this page