drizzle-team / drizzle-team/drizzle-orm
[FEATURE]: Add MSSQL table creation options
- 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
Assessment
This issue has not been assessed yet.