Actions36
- Record Actions
- Table Actions
- Field Actions
- Index Actions
- Relationship Actions
- Query Actions
- System Actions
- Batch Actions
Table → Delete Table
AI-generatedSummary
Delete a SurrealDB table by specifying its name. Optionally override the default namespace and database settings for this operation and configure connection pooling parameters for optimal performance.
Inputs
- table (required) — The name of the SurrealDB table to delete, e.g., 'person', 'product', or 'order'. You may also provide a full record ID like 'person:john', and the table part will be extracted automatically.
- options.namespace — An optional namespace to override the credential's namespace for this delete operation.
- options.database — An optional database to override the credential's database for this delete operation.
- connectionPooling.maxConnections — Maximum number of connections in the connection pool (default 10).
- connectionPooling.minConnections — Minimum number of connections to keep in the pool (default 2).
- connectionPooling.acquireTimeout — Maximum time in milliseconds to wait for a connection from the pool (default 30000).
- connectionPooling.healthCheckInterval — Interval in milliseconds between health checks for pool connections (default 60000).
- connectionPooling.maxIdleTime — Maximum idle time in milliseconds before a connection is closed (default 300000).
- connectionPooling.retryAttempts — Number of retry attempts for failed connection acquisition (default 3).
- connectionPooling.retryDelay — Delay in milliseconds between retry attempts (default 1000).
- connectionPooling.enableConnectionValidation — Whether to validate connections before use to ensure health (default true).
- connectionPooling.connectionValidationTimeout — Timeout in milliseconds for connection validation queries (default 5000).
Output shape
a single JSON object indicating the result of the delete operation
The operation returns the outcome of the delete table command. The result does not include the table data. If deletion fails, error details are provided in the returned JSON.