表模式

如果你在模式中声明一个实体,查询构建器会在查询中添加模式名称前缀:
select * from `schema`.`users

import { int, text, singlestoreSchema } from "drizzle-orm/singlestore-core";

export const mySchema = singlestoreSchema("my_schema")

export const mySchemaUsers = mySchema.table("users", {
  id: int("id").primaryKey().autoincrement(),
  name: text("name"),
});
CREATE SCHEMA `my_schema`;

CREATE TABLE `my_schema`.`users` (
  `id` serial PRIMARY KEY,
  `name` text
);