Cmdlets for HarperDB

Build 24.0.9060

Remove-HarperDB Cmdlet

Parameters   Output Objects  

Deletes HarperDB data.

Syntax

Remove-HarperDB [parameters]

Remarks

The Remove-HarperDB cmdlet allows you to use a syntax similar to SQL DELETE statements to delete HarperDB data.

$conn = Connect-HarperDB -Server '127.0.0.1' -Port 9925
Remove-HarperDB -Connection $conn -Table "[HarperDB].[cstest].Cutomers" -Id "22"
The Where parameter can also be used to specify the primary key:
Remove-HarperDB -Connection $conn -Table "exTablePowershell;" -Where "_id = 22"
The primary key can also be passed to the cmdlet along the pipeline:
Select-HarperDB -Connection $conn -Table [HarperDB].[cstest].Cutomers -Where "Country = 'US'" | Remove-HarperDB

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060