DeleteData¶

Removes all rows from the specified table by using a column and value as a single criterion, and returns the number of rows deleted.

1

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

Removes all rows from the specified table in the target data store, 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
    The name of the target schema.

string table
    The name of the target table.

string column
    The name of the column to use as criteria.

any value
    The value of the column to use as criteria.

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

Returns¶

The number of rows that were deleted.

Remarks¶

Example¶

1

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