drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: Add MSSQL table creation options

Open
#5,250 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

MSSQL / TSQL has many additional options outside of standard sql creation. for my current project i need a ledger table which is defined like so:
```
CREATE TABLE [dbo].[audit](
[... coldefs]
)
WITH (LEDGER = ON (APPEND_ONLY = ON));

```

However there does not seem like any way to add this extra configuration, an ideal way to(though not sure how possible it would be) would be to have a 4th parameter to mssqlTable()
`function mssqlTable( name: string, cols: ColDef, constraints?: (table)=>constraints[], options?: string[]|Record)`

I understand the mssql provider seems to be fairly beta, and would be happy to contribute, test etc.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.