Rows.Remove

Delete a row from a data extension.

This function times out if it runs for too long. The maximum number of rows that you can delete depends on the size of the data extension, system load, and other factors. For large deletion requests, we recommend that you implement a batching process.

Note

Syntax

1Rows.Remove(1, 2)

Properties

Ordinal	Type	Description
`1`	String	Required. The columns to search for the specified value.
`2`	String	Required. The field value used to determine which rows to delete.

Usage

This example removes all of the rows from the MembershipRewards data extension where the value in the Area column is Kensington.

1<script runat="server">
2  Platform.Load("Core","1");
3  var memberDE = DataExtension.Init("MembershipRewards");
4  var result = memberDE.Rows.Remove(["Area"], ["Kensington"]);
5</script>
6<p>Rows deleted: <ctrl:var name="result" /></p>

The only item in the response is the number of rows that were modified.