表模式
如果你在模式中声明一个实体,查询构建器会在查询中添加模式名称前缀:
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
);