Deleting all records by the workflow step

Is there an easy way how to run DELETE FROM Xy or better TRUNCATE TABLE Xy in the workflow step? I need to delete all records from the table Xy before creating new records.

If you don`t care about data audit log, you can create a stored procedure in which you can execute any SQL statements you want.

Then you call it by running a DataService.ExecuteProcedure method.

1 Like