how to delete column in sql to Laravel Migration?

Rate this post

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

Free Live Chat for Any Issue

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

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()
    {
          
    }
}

Download

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.