表结构
如果你在 schema 中声明一个实体，查询构建器会在查询中加上 schema 名称：
select * from [schema].[users]
import { int, text, mssqlSchema, nvarchar } from 'drizzle-orm/mssql-core';
export const mySchema = mssqlSchema('my_schema');
export const mySchemaUsers = mySchema.table('users', {
id: int().identity().primaryKey(),
name: text(),
color: nvarchar({ length: 100 }).default('red'),
});CREATE SCHEMA [my_schema];
CREATE TABLE [my_schema].[users] (
[id] int IDENTITY(1, 1),
[name] text,
[color] nvarchar(100) CONSTRAINT [users_color_default] DEFAULT ('red'),
CONSTRAINT [users_pkey] PRIMARY KEY([id])
);