---
title: Create a Table | Datasquirel docs
description: Create a new table inside a Datasquirel database
page_title: Create a Table
page_description: Add a new table to an existing database using the web admin panel.
---

## Overview

A **table** is a structured set of rows, where every row has the same columns (fields). Before you can add data, you need to create at least one table in your database and define its fields.

## Steps

### 1. Open a Database

Navigate to the database you want to add a table to. Click on the database from the [Databases](/admin/databases) list.

### 2. Click Add Table

On the database page, click the **Add Table** button.

<DocsImg
    alt="Tables List"
    srcLight="/images/screenshots/tables-list-white.webp"
    srcDark="/images/screenshots/tables-list-dark.webp"
/>

### 3. Name the Table

Enter a name for the table. Table names should use lowercase letters, numbers, and underscores (e.g. `blog_posts`).

### 4. Add Fields

The table creation form includes a field editor. Add at least one field to define the structure of the table. For each field, provide:

- **Field Name** — the column name (e.g. `title`, `created_at`).
- **Data Type** — the SQL data type for the column. See [Data Types](/docs/database-reference/data-types) for the full list.
- **Required** — whether the field must have a value (NOT NULL constraint).
- **Default Value** — a default value used when no value is provided.
- **More** — additional options including encryption and foreign key relationships.

See [Create Table Fields](/docs/gui-reference/databases/create-table-fields) for a detailed breakdown of each field option.

### 5. Save the Table

Click **Add Table** to create the table. It will appear in the table list for the database.

## What's Next

- [Create Table Fields](/docs/gui-reference/databases/create-table-fields) — learn more about field types and options
- [Add an Entry](/docs/gui-reference/databases/add-entry) — insert your first row
- [Create Table Indexes](/docs/gui-reference/databases/create-table-indexes) — add indexes to improve query speed
