Actions36
- Record Actions
- Table Actions
- Field Actions
- Index Actions
- Relationship Actions
- Query Actions
- System Actions
- Batch Actions
Record → Delete Record
AI-generatedSummary
Delete a record from a SurrealDB table by specifying its record ID, optionally overriding the namespace and database settings or configuring connection pooling for the operation.
Inputs
- Table — The SurrealDB table name, e.g., "person" or "product". If a full record ID including the table prefix (e.g., "person:john") is provided in the Record ID input, this field is optional as the table part will be extracted automatically.
- Record ID (required) — The ID of the record to delete. It can include the table prefix (e.g., "person:john" or "product:abc123"). If the Table input is empty, the table will be extracted from this ID.
- Options — Additional options allowing override of the namespace and database settings for this operation, independent of the configured credentials.
- Connection Pooling — Optional settings to configure connection pooling behavior, such as max/min connections, timeouts, retry attempts, and connection validation, to improve performance and reliability during the delete operation.
Output shape
a single record per input item
Each workflow item processed results in an output item reflecting the deletion action. The operation returns the deleted record's identifier or confirmation. No pagination applies. Errors for individual items are handled per n8n error conventions, visible in the item results.
Examples
Example 1: Delete a specific record using a full record ID with table prefix
Set 'Record ID' to 'person:john', leave 'Table' blank, and configure namespace and database if needed.
Example 2: Delete a record by specifying the table and record ID separately
Set 'Table' to 'product' and 'Record ID' to 'abc123' without table prefix.