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

Responsive YouTube Videos

Stripe Payment Integration With Laravel

Generate RSS Feeds in PHP Laravel

Install Packages Parallel For Faster Development In Composer

Laravel Last Executed Query In Plain SQL Statement For Debugging

File Upload In Laravel PHP

Free SSL Certificate For CPanel

Push Files To CPanel / Remote Server using FTP Software FileZilla

Create Zip File On The Fly With Streaming Download In PHP Laravel

Comment And Like System Using Disqus

Plain PHP Resumable Large File Uploads In Chunks Using FlowJs

Use Different PHP Versions In Ubuntu / Linux

Lazy Load Images In Chrome With This Simple Trick

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

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