DELETE

Delete data with type-safe DELETE operations.

Basic Delete

Use .delete().where() to delete rows:

await db.users.delete().where(id: users.id.eq('user-123'));

WHERE Clause

Always use .where() to specify which rows to delete:

// Delete single row by ID
await db.users.delete().where(id: users.id.eq('user-123'));

// Delete with multiple conditions
await db.posts.delete().where(
  userId: posts.userId.eq('user-123'),
  createdAt: posts.createdAt.lt(DateTime(2020, 1, 1)),
);

Return Value

DELETE returns Future<int> - the number of deleted rows:

final deleted = await db.users.delete().where(id: users.id.eq('user-123'));

print('Deleted $deleted row(s)');

Examples

Delete User

Future<int> deleteUser(String userId) async {
  return db.users.delete().where(id: users.id.eq(userId));
}

Delete Post

Future<int> deletePost(int postId) async {
  return db.posts.delete().where(id: posts.id.eq(postId));
}

Delete User's Posts

Future<int> deleteUserPosts(String userId) async {
  return db.posts.delete().where(userId: posts.userId.eq(userId));
}

Delete Old Records

Future<int> deleteOldComments() async {
  final cutoff = DateTime.now().subtract(Duration(days: 90));

  return db.comments.delete().where(
    createdAt: comments.createdAt.lt(cutoff),
  );
}

Caution

WARNING

DELETE without WHERE will delete all rows. Always include a WHERE clause.

// DANGEROUS - deletes all users!
// await db.users.delete();

// SAFE - deletes specific user
await db.users.delete().where(id: users.id.eq('user-123'));

Next Steps

• Transactions - Atomic operations
• SELECT - Query data
• INSERT - Insert data
• UPDATE - Update data