$Database.DeleteData

Overview¶

int $Database.DeleteData ( [dataStore], schema, table, column, value )

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

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

String schema Name of target schema

String table Name of target table

String column Name of column to use as criteria

Object value Value of column to use as criteria

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