Delete
MSSQL Plugin – Delete Action
Summary (SEO Meta Description):
The Delete Action in the MSSQL Plugin removes records from a Microsoft SQL Server table based on specified conditions.
It is useful for workflows that require cleaning up, archiving, or dynamically removing records from enterprise databases.
Overview
The Delete Action enables workflows to remove one or multiple records from a selected MSSQL table.
You can define conditions manually or via mapped workflow inputs to ensure only the intended rows are deleted.
Typical Use Cases:
- Remove outdated records from a database
- Clean up invalid or temporary entries
- Automate archiving by deleting records after exporting
- Dynamically delete rows based on workflow triggers
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select connection | Choose or create an MSSQL connection | Connection |
| Table name | Target table where records will be deleted | Dropdown |
| Condition | SQL condition for selecting rows to delete | String |
| Inputs (Manual) | Define custom inputs for conditions (optional) | NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY |
| Truncate Fields | Toggle to shorten field values if needed | Boolean |
| Schema | Select schema for validation/mapping | Schema selector |
FAQ
Q: Can I delete multiple rows at once?
A: Yes. If the condition matches multiple records, all of them will be deleted.
Q: What happens if no condition is set?
A: Without a condition, the plugin may delete all rows from the selected table. It is recommended to always set conditions.
Q: Does it support input mapping for dynamic conditions?
A: Yes. You can configure manual inputs to pass values dynamically from workflow data.
Keywords: WeHub MSSQL Plugin, MSSQL Delete Action, Microsoft SQL Server Workflow Delete, MSSQL Data Management