First, select a table to delete rows from. This can be done either by selecting a table from the pick list, or toggle the input to text mode and type the full table name.
Next, provide a
WHERE condition to select rows to be deleted. This condition can be as simple as filtering a single record to delete based on
id = 5
Alternatively, it can be used to delete multiple rows.
status = 'closed'
WHERE conditions with subqueries can also be used. Refer to the WHERE condition guide for more information.
Learn more about the other triggers and actions Workato has to offer for SQL server
- New row trigger
- New/updated row trigger
- Select actions
- Insert actions
- Update actions
- Upsert actions
- Run custom SQL action
- Execute stored procedure
Or get busy building your recipes now! Check out our