$Database.DeleteData

Overview

Removes all rows on specified table by using column and value as single criteria and returns deleted number of rows.

number $Database.DeleteData(schema: string, table: string, column: string, value: any)

Removes all rows from the specified table by the name or ID number of the Target datastore, using the column and value as the sole criteria, and returns the number of rows deleted.

number $Database.DeleteData(store: string, schema: string, table: string, column: string, value: any)

Arguments

string schema

Name of target schema

string table

Name of target table

string column

Name of column to use as criteria

any value

Value of column to use as criteria

string store

Name or Id number of target data store. This parameter is optional.

Example

$Database.DeleteData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));

Example

`
$Database.DeleteData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));