Managing Tables

Database Studio lets you create and manage tables in your DataStore directly from the browser.

Viewing Tables

Navigate to the Database page from the sidebar to see a list of all tables in your DataStore. Each table shows its name and column count.

Creating a Table

1. Click "+ New Table"
2. Enter a table name
3. Define columns:
   • Column name — the field name
   • Data type — text, integer, boolean, timestamp, etc.
   • Constraints — nullable, default value, primary key
4. Click Create

TIP

Table names should use lowercase with underscores (e.g., customer_orders). Avoid spaces and special characters.

Altering a Table

To modify an existing table's structure:

1. Open the table by clicking its name
2. Access the table settings or schema view
3. You can:
   • Add columns — define new fields
   • Modify columns — change data types or constraints
   • Drop columns — remove fields

WARNING

Dropping a column permanently deletes all data in that column. This cannot be undone.

Dropping a Table

To delete a table entirely:

1. Open the table
2. Click Delete Table (or the equivalent action)
3. Confirm the deletion

DANGER

Dropping a table permanently deletes the table and all its data. Any workflows using DataStore nodes that reference this table will fail.