SQLite Doesn't Support Dropping Foreign Keys in Laravel

Many times when you are working on SQLite database with Laravel you might have come across a wired error that SQLite doesn't support dropping foreign keys.

The reason is SQLite database has no concept called foreign keys. Let's fix this issue in Laravel.

---

Install Doctrine DBAL Package

To fix the DBAL issues make sure to install the following package.

composer require doctrine/dbal

---

Check if SQLite Driver is being Used

Before

Example 1

public function down()
{
    Schema::table('comments', function (Blueprint $table) {
        $table->dropForeign(['parent_id']);

        $table->dropColumn(['parent_id']);
    });
}

After (Driver conditional check)

Example 1

public function down()
{
    Schema::table('comments', function (Blueprint $table) {
        /** Make sure to put this condition to check if driver is SQLite */
        if (DB::getDriverName() !== 'sqlite') {
            $table->dropForeign(['parent_id']);
        }

        $table->dropColumn(['parent_id']);
    });
}

You can put this condition for multiple columns too.

Example 2

public function down()
{
    Schema::table('payments', function (Blueprint $table) {
        if (DB::getDriverName() !== 'sqlite') {
            $table->dropForeign(['coupon_id']);
            $table->dropForeign(['currency_id']);
        }


        $table->dropColumn(['status', 'currency_id', 'coupon_id', 'notes', 'invoice_number']);
    });
}

I hope this might have solved your issues. Happy coding.

Random Articles For You

Sass or SCSS @mixin vs @extends vs Placeholder (%)

Factories To Speed Up Test-Driven Development In Laravel

Basic Server Security Setup For Ubuntu / Linux

Install NGINX In Linux / Ubuntu And Managing

Send SMS With Amazon SNS (Simple Notification Service) Using PHP

Proper Way To Validate MIME Type Of Files While Handling File Uploads In PHP

What Is Method Chaining In PHP?

Route Model Binding In Laravel & Change Default Column id To Another Column

Random Rows In Laravel

Generate Fake Data In PHP With Faker

Create Gmail App Password For SMTP Mails

Cache Static Files With NGINX Server

Dependency Dropdowns With Javascript And PHP

Free SSL Certificate In cPanel With ZeroSSL & Certbot

Create A Composer Package? Test It Locally And Add To Packagist Repository