Delete

delete() removes matching rows. Add where() to scope it.

Delete with a filter

await db.from(users).where("id", "=", 1).delete();

Delete all rows

Omit where() to delete everything in the table:

await db.from(users).delete();

No filter = truncate

Without where(), delete() removes every row. Use with care — there is no undo unless you have a backup or migration.

How it compiles

db.from(users).where("id", "=", 1).delete();
// → DELETE FROM "users" WHERE "id" = ?

Real-world example

export async function removeUser(id: number) {
  await db.from(users).where("id", "=", id).delete();
}

Best practices

• Always scope deletes with where() unless you intend a full clear.
• Consider a soft-delete (update({ deletedAt })) for recoverable data.
• Wrap destructive deletes in a transaction when multiple tables are involved.

Common mistakes

• Forgetting where() and wiping the table.
• Deleting without a FK ON DELETE strategy — orphans may remain.

Related

• Update — modify instead of remove.
• Filtering — scope the delete.