import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/deps.ts";
const { DeleteQueryBuilder } = kysely;
Changes a delete from
query into a delete top from
query.
top
clause is only supported by some dialects like MS SQL Server.
Examples
Delete the first 5 rows:
await db
.deleteFrom('person')
.top(5)
.where('age', '>', 18)
.executeTakeFirstOrThrow()
The generated SQL (MS SQL Server):
delete top(5) from "person" where "age" > @1
Delete the first 50% of rows:
await db
.deleteFrom('person')
.top(50, 'percent')
.where('age', '>', 18)
.executeTakeFirstOrThrow()
The generated SQL (MS SQL Server):
delete top(50) percent from "person" where "age" > @1
Returns
DeleteQueryBuilder<DB, TB, O>