DeleteData¶

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

1

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

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.

1

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

Parameters¶

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.

Remarks¶

Example¶

1

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