Microsoft SQL Server on-premises - Delete SQL records

Use the Microsoft SQL Server on-premises - Delete SQL records action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to delete specific rows of data in a SQL table.

For more information about the Microsoft SQL Server on-premises connector, go to Microsoft SQL Server on-premises.

Before you begin: 

Jump to:

Configure the Microsoft SQL Server on-premises - Delete SQL records action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  2. Select a Connection. If you do not have a connection, see Add a connection.
  1. Select the SQL Table to delete records from.
  2. Click the add condition button to define which records to delete.
  3. Select the condition When and Operator values.
  4. Specify the Value that must be matched.
  5. Create or select a variable for the output.

Microsoft SQL Server on-premises - Delete SQL records action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Microsoft SQL Server on-premises connection to use to delete records.

To refresh the available connections, click .

(n/a)
Table

The SQL table you want to delete records from.

 Text, Decimal, Integer, Boolean, DateTime, Collection
  Add condition

Click Add condition to define which records to delete. This builds a SQL WHERE statement defining what records to delete.

When: The column selected for the condition.

Operator: The operator type of the conditional case statement, such as equals, does not equal, is empty, is not empty, contains, begins with, or ends with.

Value: The specific value searched for.

Summary: A short description of your condition.

For example, WHEN LastName equals Smith would delete all the records in that table where Smith is the value of the LastName column.

 Text, Decimal, Integer, Boolean, DateTime, Collection
Output Records affected

Stores the number of SQL records deleted.

 Integer