# SQL Server - Delete actions
# Delete rows
This action lets you delete rows based on certain criteria defined by a
This action should be tested and used with care, as it will PERMANENTLY delete rows in your table. Testing should be done on a test database
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.
# WHERE condition
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.
# Next steps
Learn more about the other triggers and actions Workato has to offer for SQL server
- New row trigger
- New/updated row trigger
- Scheduled query 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