---
title: "Create Table"
description: "Local-first visual environment for building and running AI workflows. Build agents visually, deploy anywhere, privacy by design."
canonical: https://docs.nodetool.ai/nodes/lib/sqlite/createtable
markdown: https://docs.nodetool.ai/nodes/lib/sqlite/createtable.md
product: NodeTool
source: https://github.com/nodetool-ai/nodetool/blob/main/docs/nodes/lib/sqlite/createtable.md
---

# Create Table

**Type:** `lib.sqlite.CreateTable`

**Namespace:** `lib.sqlite`

## Description

Create a new SQLite table with specified columns.
    sqlite, database, table, create, schema

    Use cases:
    - Initialize database schema for flashcards
    - Set up tables for persistent storage
    - Create memory structures for agents

## Properties

| Property | Type | Description | Default |
|----------|------|-------------|---------|
| database_name | `str` | Name of the SQLite database file | `memory.db` |
| table_name | `str` | Name of the table to create | `flashcards` |
| columns | `record_type` | Column definitions | `{"type":"record_type","columns":[]}` |
| add_primary_key | `bool` | Automatically make first integer column PRIMARY KEY AUTOINCREMENT | `true` |
| if_not_exists | `bool` | Only create table if it doesn't exist | `true` |

## Outputs

| Output | Type | Description |
|--------|------|-------------|
| database_name | `str` |  |
| table_name | `str` |  |
| columns | `record_type` |  |

## Related Nodes

Browse other nodes in the [lib.sqlite](./) namespace.