How to Remove Columns From Existing Table in Laravel Migration

Remove/drop column from existing table using migration in laravel; Through this tutorial, we will learn how to remove/drop columns from existing table using migration in laravel 10|9|8 apps.

Laravel 10|9|8 Migration Drop Columns From Existing DB Table

There are a three condition and solution has been available to remove or drop columns from exiting table using migration in laravel 10|9|8; as follows:

• Drop Column using Migration
• Drop Multiple Column using Migration
• Drop Column If Exists using Migration

Let us assume that we have a post table in our database. And we have to delete some columns from that table. So for this, we have to first create a migration file.

Before using the solution given below, we should create a migration file by using the command given below:

php artisan make:migration drop_posts_table_columns --table=posts

Note:- The above command was made for understanding only. We can name our migration file whatever.

Drop Column using Migration

In DropPostsTableColumn class content a up() method, which is used to remove column from table using migration in laravel:

<?php
  
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
  
class DropPostsTableColumn extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('posts', function (Blueprint $table) {
            $table->dropColumn('content');
        });
    }
  
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
          
    }

Drop Multiple Column using Migration

In DropPostsTableColumn class content a up() method, which is used to remove or drop multiple column from table using migration in laravel:

<?php
  
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
  
class DropPostsTableColumn extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('posts', function (Blueprint $table) {
            $table->dropColumn(['content', 'title']);
        });
    }
  
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
          
    }
}

Drop Column If Exists using Migration

Use the following method to remove or drop column if exits using migration in laravel:

<?php
  
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
  
class DropPostsTableColumn extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        if (Schema::hasColumn('posts', 'content')){
  
            Schema::table('posts', function (Blueprint $table) {
                $table->dropColumn('content');
            });
        }
    }
  
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
          
    }
}

Then, execute the migration command to remove column from the table.

php artisan migrate

Conclusion

Through this tutorial, we have learned how to remove/drop column from existing table using migration in laravel apps.

Recommended Laravel Tutorials