ODBC/JDBC Gateway icon

ODBC/JDBC Gateway

Esegue query SQL su RDBMS multipli tramite il gateway ODBC/JDBC

Actions9

Table → Delete

AI-generated

Summary

Deletes rows from a selected table through a preconfigured ODBC/JDBC Gateway connection. Add WHERE conditions to target rows, or enable Delete All Rows to allow deleting the entire table when no valid conditions are generated.

Inputs

  • Connection Name or ID (required) — Preconfigured gateway connection used to run the delete.
  • Schema Name or ID — Schema containing the table; leave empty to use the driver default.
  • Table Name or ID (required) — Table from which to delete rows.
  • Conditions (WHERE) — Optional column comparisons using equals, not equals, greater/less than, LIKE, IN, IS NULL, or IS NOT NULL. Multiple conditions are joined with AND or OR. Values are bound query parameters; IN takes a comma-separated list, and null checks ignore the value. Conditions without a column are skipped.
  • Combine Conditions — Joins multiple WHERE conditions with AND (default) or OR.
  • Delete All Rows — Defaults to false. Must be enabled if the built query has no WHERE clause; otherwise the operation errors instead of deleting every row.

Output shape

One item per input item, containing the selected table name and the gateway-reported affected row count.

The output JSON is {"table": "...", "affected_rows": number|null}. If no conditions produce a WHERE clause and Delete All Rows is enabled, the delete applies to the whole table. With continue-on-fail enabled, an input item that errors produces {"error": "..."} instead.

Links

Discussion