Share this:

Hello dev, Today we are going to learn Laravel 10 Deleting All Rows in a Table using Eloquent. In the world of web development, Laravel has established itself as a popular PHP framework due to its rich feature set and elegant syntax.

With each new version, Laravel brings improvements and additional functionalities that make developers’ lives easier. In Laravel 10, one of the essential tasks you may encounter is deleting all rows in a table.

In this blog post, we’ll explore how to achieve this efficiently using Eloquent, Laravel’s powerful ORM (Object-Relational Mapping) tool.

Also Read: Running Specific Migrations in Laravel 10: A Step-by-Step Guide

Understanding Eloquent and ORM

Before diving into the specifics of deleting rows, let’s briefly explore Eloquent and ORM. Eloquent provides an expressive, fluent interface to work with your database. It allows you to interact with database tables using PHP objects and provides a higher level of abstraction over raw SQL queries.

ORM, or Object-Relational Mapping, maps database tables to objects in your application, enabling you to perform database operations using familiar object-oriented syntax. Eloquent is Laravel’s implementation of the ORM concept and offers a seamless way to interact with your database.

Deleting All Rows in a Table using Eloquent

To delete all rows in a table using Eloquent, we’ll leverage the power of the query builder. Laravel’s query builder provides a simple and intuitive interface to construct SQL queries programmatically.

Here’s a step-by-step guide on how to delete all rows in a table using Eloquent in Laravel 10:

Step 1: Import the necessary classes

First, ensure that you have imported the required classes at the top of your file:

use Illuminate\Support\Facades\DB;

Step 2: Delete all rows

To delete all rows in a table, we can use the delete() method provided by Eloquent. Here’s how you can accomplish this:


Replace 'your_table_name' with the actual name of the table you want to delete all rows from.

Step 3: Confirm deletion (optional)

If you want to confirm that the deletion was successful, you can store the result of the delete() method call in a variable and check its value:

$deleted = DB::table('your_table_name')->delete();

if ($deleted) {
    // Deletion successful
} else {
    // Deletion failed

This way, you can handle any error scenarios or provide appropriate feedback to users if needed.

Also Read: How to set up file permissions for Laravel 10?


In Laravel 10, managing data in your application becomes more streamlined and efficient. With Eloquent and its powerful query builder, deleting all rows in a table is a straightforward process. By leveraging the expressive syntax and ORM capabilities of Laravel, you can focus on building robust applications without getting lost in the complexities of raw SQL.

Remember to exercise caution when deleting data, as it is an irreversible operation. Always ensure that you have appropriate backups or safeguards in place before performing any mass deletion.

By mastering this technique in Laravel 10, you can confidently handle data management tasks and maintain a clean, organized database system within your application.

Happy coding with Laravel 10 and Eloquent!

Share this:

Categorized in: