Actions36
- Record Actions
- Table Actions
- Field Actions
- Index Actions
- Relationship Actions
- Query Actions
- System Actions
- Batch Actions
Table → Delete All Records
AI-generatedSummary
Delete all records from a specified SurrealDB table, optionally overriding namespace and database settings, and configure connection pooling parameters to optimize performance.
Inputs
- Table (required) — The SurrealDB table name from which to delete all records. Can be a table name (e.g., "person") or a full record ID (e.g., "person:john") from which the table part is extracted automatically.
- Namespace — Optional namespace to use for this operation, overriding the credential's namespace setting.
- Database — Optional database to use for this operation, overriding the credential's database setting.
- Connection Pooling — Settings for connection pooling to improve performance, including max/min connections, acquire timeout, health check interval, max idle time, retry attempts and delays, and connection validation options.
Output shape
a single record containing the result of the delete operation (usually an acknowledgment or empty result).
The node returns success or error results per item processed. Errors are handled and formatted appropriately. No pagination applies to this operation.
Examples
Example 1: Deleting all records in the 'person' table with default connection pooling settings.
Set Table to 'person' and leave optional fields blank to use default credentials and pool settings.
Example 2: Deleting all records from a table in a specific namespace and database with custom connection pool settings.
Specify Table with the target table name, override Namespace and Database parameters, and adjust connection pooling parameters as needed.