Actions36
- Record Actions
- Table Actions
- Field Actions
- Index Actions
- Relationship Actions
- Query Actions
- System Actions
- Batch Actions
Table → Create Table
AI-generatedSummary
Create a new table in SurrealDB with configurable options such as table type, schema mode, and optional namespace and database overrides.
Inputs
- Table (required) — Name of the SurrealDB table to create (e.g., 'person', 'product', 'order'). It also accepts full record IDs and extracts the table part automatically.
- Options — Additional settings for the table, including Table Type (NORMAL, ANY, RELATION), Schema Mode (SCHEMALESS or SCHEMAFULL), JSON Schema definition (required if Schema Mode is SCHEMAFULL), Namespace, and Database to override credential defaults.
- Connection Pooling — Settings to configure connection pooling such as max/min connections, acquire timeout, health check interval, retry attempts and delays, and validation options for connections.
Output shape
a single record containing the result of the 'CREATE TABLE' operation as returned by SurrealDB, indicating success or failure
This operation returns the raw response from SurrealDB upon attempting to create the table. It supports operation per incoming item but typically acts once per execution. Namespace and database can be optionally overridden per request, otherwise using credential defaults.
Examples
Example 1: Create a new standard table named 'person' with schemaless mode in the default namespace and database
Set 'Table' to 'person', leave options as default (Table Type: NORMAL, Schema Mode: SCHEMALESS), no overrides for namespace or database.