Azure SQL -Delete SQL records

Use the Azure SQL - Delete SQL records action A tool for building the processes, logic, and direction within workflows. to delete SQL records.

For more information about the Azure SQL connector, go to Azure SQL.

Configure the Azure SQL - Delete SQL records

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.

3. Select the SQL Table.
4. Click the Add condition button to define which records to delete.
5. Select the condition When and Operator values.
6. Specify the Value that must be matched.
7. Create or select a variable for the output.

Azure SQL - Delete SQL records action fields and settings

Section	Field	Description	Variable types
(Unlabeled)	Connection Credentials and other settings required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.	The Azure SQL connection is used to create, update, and delete records. To refresh the available connections, click .	(n/a)
	Table	The list is populated based on the connection selected. Select the table to delete the records from.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Add Conditions	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 amount of records deleted.	Integer