Get started
Overview PostgreSQL MySQL SQLite Manage schema
Overview Column types Indexes & Constraints Sequences Migrations Views Schemas Access your data
Query Select Insert Update Delete Filters Joins Magic sql`` operator Performance
Queries Serverless Advanced
Set Operations Generated Columns Transactions Batch Dynamic query building Read Replicas Custom types Goodies Extensions
Prisma ESLint Plugin drizzle-zod drizzle-typebox drizzle-valibot drizzle-graphql Table schemas
PostgreSQL
MySQL
SQLite
Drizzle ORM provides you an API for declaring SQL schemas for PostgreSQL and MySQL dialects.
If you declare an entity within a schema, query builder will prepend schema names in queries:
select * from "schema"."users"
PostgreSQL
MySQL
SQLite
SQLite does not have support for schemas 😕