Back to Drizzle Orm

CreateTable

src/mdx/get-started/mssql/CreateTable.mdx

latest395 B
Original Source

Create a schema.ts file in the src/db directory and declare your table:

typescript
import { int, mssqlTable, varchar } from "drizzle-orm/mssql-core";

export const usersTable = mssqlTable("users", {
  id: int().primaryKey(),
  name: varchar({ length: 255 }).notNull(),
  age: int().notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
});