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

Google reCAPTCHA Integration In PHP Laravel Forms

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

Free Live Chat Integration Using TAWK.IO

Make Laravel Controllers Slim By Skimming Form Validation Request

Unable to prepare route [{fallbackPlaceholder}] for serialization. Uses Closure In Laravel

Cache Static Files With NGINX Server

Add Analytics To AMP (Accelerated Mobile Pages) HTML Pages

GitHub Login With PHP Laravel Socialite

Run Raw Queries Securely In Laravel

Test Your Local Developing Laravel Web Application From Phone Browser Without Any Software

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

Send Email In PHP With PHPMailer

Custom Validation Rules In PHP Laravel (Using Artisan Command)

Install Linux, Apache, MYSQL, PHP (LAMP Stack) on Ubuntu

Automate Repeating Tasks In Linux Server With Cronjobs