n8n-nodes-azure-sql icon

n8n-nodes-azure-sql

Connect to Azure SQL Database using Entra ID authentication

Actions4

Delete

AI-generated

Summary

Delete rows from an Azure SQL table using an optional WHERE clause.

Inputs

  • server (required) — Azure SQL Server hostname (e.g., myserver.database.windows.net).
  • database (required) — Database name to connect to.
  • table (required) — Name of the table to delete rows from.
  • whereClause — WHERE clause (without the WHERE keyword) that filters rows for deletion.
  • additionalOptions — Additional connection and request settings. All are optional with sensible defaults.

Output shape

object

An array with a single object containing the operation result. The object includes: success (boolean), rowsAffected (number), and operation (string, always 'delete').

Examples

Example 1: Delete a specific row by ID

Set server, database, table, and whereClause to 'ID = 123'.

Discussion