SQL Delete
You can delete all rows in the table:
await db.delete(users);And you can delete with filters and conditions:
await db.delete(users).where(eq(users.name, 'Dan'));Output
You can delete a row and get it back in PostgreSQL:
const deletedUser = await db.delete(users)
.where(eq(users.name, 'Dan'))
.output();
// partial return
const deletedUserId = await db.delete(users)
.where(eq(users.name, "Dan"))
.output({ deletedId: users.id });
// deletedUserId: { deletedId: number }[]delete from [users] output DELETED.[id], DELETED.[name], DELETED.[age] where [users].[name] = 'Dan'
delete from [users] output DELETED.[id] where [users].[name] = 'Dan'