NeonInstall

Summary

Delete rows from a Neon database table.

Inputs

• schema — The schema to use
• table — The table to use
• deleteCommand — The delete command to execute (delete rows, truncate table, or drop table)
• restartSequences — Whether to reset identity (auto‑increment) columns to their initial values
• where — If not set, all rows will be selected; used to add condition constraints
• combineConditions — How to combine the conditions defined in "Select Rows": AND requires all conditions to be true, OR requires at least one condition to be true
• options — Execution options for the delete operation such as cascade, delay closing idle connection, output column names, query mode, etc.

Output shape

no body — success/failure only

On success returns nothing; on failure throws a NodeOperationError with error details.

Examples

Example 1: Delete all rows in a table using default command.

resource=Row, operation=delete, table=users, deleteCommand=delete, restartSequences=false

Example 2: Truncate a table and reset sequences.

resource=Row, operation=delete, table=orders, deleteCommand=truncate, restartSequences=true, cascade=true

Example 3: Delete rows matching a condition.

resource=Row, operation=delete, table=products, deleteCommand=delete, where=[{column=ID, condition=equal, value=5}], combineConditions=AND