how to delete column in sql to Laravel Migration?

how to delete column in sql – delete Column If Exists, delete Multiple Column, delete Column using Migration.

how to delete column in sql – How to Remove Column from Table in Laravel Migration?

drop column migration laravel main 3 way to remove Column in sql. Laravel 6 Drop Column If Exists MySQL Using Migration

Free Live Chat for Any Issue

Example 1) delete Column using Migration

<?php
  
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
  
class ChangeArticlesTableColumn extends Migration
{
    /**
     * Run the migrations.
     * created By www.pakainfo.com
     * @return void
     */
    public function up()
    {
        Schema::table('articles', function (Blueprint $table) {
            $table->dropColumn('body');
        });
    }
  
    /**
     * Reverse the migrations.
     * created By www.pakainfo.com
     * @return void
     */
    public function down()
    {
          
    }
}

Example : 2) delete Multiple Column using Migration

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

Example : 3) delete Column If Exists using Migration

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

I hope you get an idea about how to delete column in sql?.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, donโ€™t forget to share.

Rate this post