Schema Management
Creating tables in development and managing production migrations.
This guide has been moved to Database Management & Migrations.
Learn how to configure databases, run development table synchronization with syncSchema, and manage production PostgreSQL migrations with Drizzle Kit.
Please see the canonical guide: Database Management & Migrations.
Schema
This is the example table in Database Management & Migrations. syncSchema creates your declared tables; it does not add framework columns.
Table Name: users
| Field | Type | Description |
|---|---|---|
id | text | Row identifier. PK Default: crypto.randomUUID() (application) |
email | text | Unique email address. Unique |