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.

Articles For You

Increase Session Timeout In Laravel

What Is HTTP? Different HTTP Methods And Status Codes Explained With Examples

Laravel Last Executed Query In Plain SQL Statement For Debugging

Automate Repeating Tasks In Linux Server With Cronjobs

Writing Clean Code In PHP

Localization In Laravel REST API

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

PHP extension ext-intl * is missing

Create Gmail App Password For SMTP Mails

Setup AMP (Accelerated Mobile Pages) In PHP Laravel

@stack @push and @prepend In Laravel Blade

TRUNCATE vs DELETE In MySQL

Basic Server Security Setup For Ubuntu / Linux

File Upload In Laravel PHP

What Is Composer? How Does It Work? Useful Composer Commands And Usage